MapInfo Products KnowledgeBase

Product: MapInfo Professional
Version: 8.0, 7.8, 7.5
Platform: All Windows Platforms
Category: Documentation

Summary:
Updating only certain records in table.

Question:
When a table contains multiple records, how can only certain records be updating without effecting the entire table? Here is an example table:



How can only the records with the value of "ABC" in the Store field be updated with a value of "Pink" in the Color field?

Answer:
1. First, select the desired records from the table. Chose Query>Select:



1. Choose the correct table to select from
2. Click on assist
3. Choose the correct column from the columns dropdown.
**After this is chosen, enter an "=" sign followed by the value to select contained in double quotes as seen above.

Click OK twice.

This will open a query of just the specified stores, such as "abc":



Now, to update the color field to pink, choose Table>Update Column:



"Table to Update" should be the query, in this case, Query1.
"Column to Update" should be the column to update. In this example, the field "color is chosen.
"Get Value From Table" will also be the query table.
"Value" will be what the value to change it to. If this is being updated with a string value, be sure to enclose the value in double quotes.
Click OK.

Now, when viewing the original store_table, the updated values will be displayed.





Last Modified: 04/17/2006 04:03:18 PM
Document URL: http://testdrive.mapinfo.com/techsupp/miprod.nsf/kbase_by_product/01AF0989132E3D54852571530067E96B

Updating only certain records in table.^01AF0989132E3D54852571530067E96B^Y