Mats,
I have seen this as well on WinXP. I also do a Pack Table before using
the Add Column statement.
So it might not just be connected to the OS ...
Peter Horsbøll Møller
GIS Developer, MTM
Geographical
Information & IT
COWI A/S
Odensevej
95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Elfström
Sent: Thursday, June 29, 2006 6:40 PM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] Update table crashes for no apparent reason
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 MapInfo-L@lists.directionsmag.com http://www.directionsmag.com/mailman/listinfo/mapinfo-l
