Make sure your text column in Access is no more than 254 chars wide. If you have made it wider, you'll have to push the update command thru to Access using ODBC and Server_Execute.
MapInfo only supports 254 chars in a text column. Peter Horsb�ll M�ller GIS Developer 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 -----Original Message----- From: David Baker [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 4:32 AM To: [EMAIL PROTECTED] Subject: Re: MI-L Editing Access tables from within MapInfo On 28 Apr 2004 at 10:07, David Baker <[EMAIL PROTECTED]> wrote: > Select * from Vessels where Vessels.ID = cownt > TempNum = Vessels.RowID > Update Vessels Set UseManualHeading = VInfo(cownt).UseManHdg Where > RowID = TempNum Update Vessels Set Name = VInfo(cownt).VName Where > RowID = TempNum Very messy formatting - should be 4 lines like this: Select * from Vessels where Vessels.ID = cownt TempNum = Vessels.RowID Update Vessels Set UseManualHeading=VInfo(cownt).UseManHdg Where RowID=TempNum Update Vessels Set Name = VInfo(cownt).VName Where RowID = TempNum The 3rd line works ok, but the 4th line gives the error. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11554 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11557
