Update Column is also useful to put graphic information into columns so that it is visible. Tables that contain map objects store the graphic information about these objects invisibly. Using Update Column, you can bring some of that information into a column so it can be viewed in a Browser. Update Column with CentroidX(Obj), CentroidY(Obj) uses the Session Projection Preferences (if set), otherwise it defaults to Longitude/Latitude. For example, you want to display the longitude and latitude coordinates of a table of radio station point locations in a Browser. In this example, you are only working with one table, RADIOLOC, but you still use Update Column as in the Add Temporary Column example.
To display the longitude and latitude coordinates of a table in a Browser:
- View the table structure (on the TABLE tab, in the Maintenance group, click Table, and Table Structure) to ensure that there are not already fields that contain longitude and latitude coordinates internal to the table.
Before you can update the table, add two columns (for instance, call them Long and Lat) to contain the coordinates. When you change the structure of the table in this way, the table is removed from any open window. The table is still open and ready for updating.
- On the TABLE tab, in the Edit group, click Update Column from the Edit group and specify RADIOLOC as the table to update and as the Get Value From Table.
- Choose Long as the Column to Update.
- In the Value box you must specify an expression to retrieve the longitude.
- Click the Assist button to bring up the Expression dialog box.
- From the Functions list choose CentroidX to return the expression CentroidX(obj).
- Click OK to return to the Update Column dialog box. The expression is now in the Value box.
- Click OK. MapInfo Pro calculates the information and places a longitude coordinate for each radio station in the Long column.
- Repeat the process to retrieve latitude coordinates using the CentroidY(obj) expression.
- On the HOME tab, click Save Table to store the coordinates in the RADIOLOC table.
Mouse Wheel Support for Browser Window
When you are working in the Browser window, you can use the mouse wheel to scroll through the records. Roll the mouse button down to scroll down the list, and roll the mouse button up to scroll up the list. You can still use the Tab key to scroll right and the <Shift+Tab> keys to scroll left in the Browser window.
For a list of keystrokes to help you navigate in a Browser window, see Shortcuts for the Browser Window.
Adding a Row to a Table
You can add a temporary row to an editable MapInfo table.
To add a new row:
- On the TABLE tab, click the New Browser option.
- Choose an editable table from the drop-down list.
- Click OK to display the table in a Browser window.
- Choose Add New Row from the Edit group in the TABLE tab (or press Ctrl+E). A new row is added to the bottom of the table.
- Enter data in the new row.
When you are finished adding rows, on the HOME tab, in the File group, click Save Table to save new data.