Hi All!
I have just come across (and solved) a very strange error in MapInfo Pro 8.
I wanted to make a join update, that is add some value from another table for posts where an index field was equal.
The code, as used in my program, or displayed in the MapBasic window is like this (tablename and column names altered)
Add Column "EditTable" (IN_COLUMN) >From SourceTable Set To SOURCE_COLUMN Where COL10 = COL1
For some reason, this line failed on the customers workstation while it had no problem whatsoever on my workstation.
The error message was simply "Cannot update table EditTable". No reason was given.
I tried to add the string to the MapBasic window with the same result. I tried the GUI, Update Table (which produces the code above). That did not work either.
Then I copied the exact table from their computer to mine, and the everything was OK. In short, I was never able to reproduce the error but it occurred every time at the customers office.
A a last resort I ran a compress table at the customer, and then the problem went away! Apparently deleted records was the cause, but why not on my computer?
Difference: I am running Windows XP, and they are using Windows 2000. Otherwise same MapInfo version, patches and all.
I was wondering if anyone has seen this, that a join update fails if the tables has deleted records?
Or that MapInfo behaves differently in Win2k and WinXP environments?
Hälsning / Best regards Mats.E
________________________
FB Engineering AB
Södra Förstadsgatan 26
211 43 Malmö
Tel: 040-660 25 50
Mobil: 0705-27 60 27
Fax: 040-660 25 99
[EMAIL PROTECTED]
www.fbe.se
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
