I am trying to update the field of a master table through a temporary query
that I have made on that same master table. My reason for doing so is to avoid
updating all records in the master table ( to no value or zero) when attempting
to update the entire table directly.
Therefore, I run a SQL query first to create the temporary query. This query
selects the similar records found in another smaller table with the same unique
ID. After I have this temp query with the subset of records to be updated
linked to the master table, I run the table update using a join and setting the
appropriate fileds. My problem is that the wrong field is updated everytime.
MapInfo seems to look for the fields to be in a particular order or something.
MapInfo is updating, but to the wrong field!
Has anybody ever had this happen? Any suggestions about overcoming this one?
Any suggestions appreciated.
---------------------------------
Do you Yahoo!?
Yahoo! Search presents - Jib Jab's 'Second Term'
