Andrew,
You cannot perform an update like this in MapInfo.
Update tablename set column = expression [where RowID = idNum] is the
syntax.
Try
***
Select elev_new.status from elev_new, elev_FEATURES_CURRENT where
elev_new.featID = elev_FEATURES_CURRENT.featId into tmpUpdat
Hello Andrew,
The problem is that MapInfo's SQL implementation does not support a fully
featured WHERE clause for an UPDATE statement. The only WHERE that is
possible is using the internal "rowid" field. This problem was highlighted
in a message posted to the list earlier today.
You can get aroun