My Spatialite Database (Point Layer) looks like this (arch_locations.sqlite)
Fields: pkuid short_ID name geometry X Y
The field "X" and"Y" I added later (after first creation of DB) using the editing functions within the attribute table. They are of type "decimal number double" and I assigned the expressions $x and $y. Now they show X/Y Coordinates for viewing in an Access Database I have linked to the Spatialite Database through ODBC.
Is it possible for me to move a Point on the layer by manually changing the values in the X and Y column? I will have exact coordinates for some points while others will derive their location through digitalizing georeferenced scanned maps.
Devdatta Tengshe hinted that this might be possible in my other question. Thanks for reading!
Edit to clear things up: I created the Database in QGIS through "Layer - new - spatialite Layer". I set it to Point and geometry and digitalized some points on a georeferenced map. Then I wanted to have two columns which show me X/Y Coordinates to be viewed in Access. I asked here how to do it: How to add columns with x/y data to Spatialite Layer?
Following this advice I went to the attribute table of the layer, enabled editing and added two columns. Then I used the field calculator to put in the two new columns the expressions $x and $y.
Now I only want to move some of the points I digitalized to an exact position by entering the x/y coordinates in those two columns. It doesn´t matter if I have to add the coordinated somewhere else I just want some points to be moved slightly.