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 tmpUpdateMe NoSelect Update tmpUpdateMe set status = Chr$(34) & "Modified" & Chr$(34) Close Table tmpUpdateMe *************************** Cheers Ian Ian Tidy GIS Administrator Works Asset Napier City Council mailto:[EMAIL PROTECTED] http://www.napier.govt.nz -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 September 2003 10:28 a.m. To: [EMAIL PROTECTED] Subject: MI-L Cannot perform this operation on field featID I'm getting the following error. Cannot perform this operation on field featID from the following: szCmdStr = "Update elev_new set status = " & Chr$(34) & "Modified" & Chr$(34) & " where featId = " & elev_FEATURES_CURRENT.featId Run Command szCmdStr Any ideas why this is a problem? Andrew Regards Andrew ------------------------------------------------ The information in this e-mail together with any attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any form of review, disclosure, modification, distribution and/or publication of this e-mail message is prohibited. If you have received this message in error, you are asked to inform the sender as quickly as possible and delete this message and any copies of this message from your computer and/or your computer system network. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8343 ###################################################################### This e-mail message has been scanned and cleared by MailMarshal ###################################################################### ###################################################################### Attention: This e-mail message and accompanying data may contain information that is confidential and subject to legal privilege. Any information provided is given in good faith. However unless specifically stated to the contrary, Napier City Council accepts no liability for the content of this e-mail or for the consequences of any action taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that any use, dissemination, distribution or copying of this message or data is prohibited. If you received this e-mail message in error, please notify us immediately and erase all copies of this message and attachments. Thank you. ###################################################################### --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8345
