THis is sort of a question/ answer watchit warning for the update table command.
If you want to update a table that has some deleted records in it with data from another table (ie. add column TargetTable(TargetField) From SourceTable Set to SourceField Where IndexField=IndexField), you will get a "Cannot Update Table .." message that is quite mystifying for a while.
You either need to pack the target table or select out valid records with a selection such as Select * from TargetTable Where Obj Into ValidTargetTable. You can then update the selection.
I am sure that I didn't used to have this issue. Three seems to be soemthing different in the latre versions in how MapInfo selects records (including deleted records) or something.
Anyway, thought I should share this so noone else wastes a few hours like i have just done.
r --
Robert Crossley
Agtrix P/L 9 Short St PO Box 63 New Brighton 2483 Far Southern Queensland AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11853
