Hello Andrew, The problem is that MapInfo's SQL implementation does not support a fully featured WHERE clause for an UPDATE statement. The only WHERE that is possible is using the internal "rowid" field. This problem was highlighted in a message posted to the list earlier today.
You can get around the problem by executing a SELECT statement to "capture" your rows and then do an unconditional UPDATE. E.g. select * from elev_new where featId = elev_FEATURES_CURRENT.featId into TO_UPDATE update TO_UPDATE set status = "Modified" close table TO_UPDATE By the way, you don't need to build a string command and execute it in this case. Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 23:28 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 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8344
