Thanks Dimitri I'm on day 2 trying to add a new geom field to my Table named "A Table" and fill it with a computed field. Here's my best determination of the workflow. 1. In my table "A", click Edit > Schema (because the right-most column in my table A does not have an asterisk to click and add a new field) 2. In Schema, click <new field>, name it "Label Centroid" make it type "geom". Moved to Expression box however unable to proceed here as I don't know what to what to put in. Have read the help manual but did not find anything applicable. Proceded with adding a new field, it is filled with <NULL>. 3. Open Command window CTRL Tilde. Drag my Table A into right hand column to see fields. Searched in lower left box for "centroid", could not find any centroid functions. Did find some functions containing the word "center". Selected GeomCenter(<geom>, <tolerance>): <valuex2> as most likely. Created query with my limited knowledge of SQL. Select * from [A Table] SET [Label Centroid]=GeomCenter([Geom], 0) 4. When run I get an "invalid object reference". Add a geom field to the table and create it as a computed field that takes the centroid of the Geom field.
Dimitri, can you provide a bit more detail please on how to do this? I've read what I think are relevant parts of the manual on editing tables and adding new fields. I have a map mostly ready for a meeting but having labels in the centre of areas would be better than at a point along an area border. I have to print the maps today so have reverted back to making a copy of table "A", transforming area to points to use as label centres then creating and styling the labels.
|