Make your selection first, then RUN MENU COMMAND M_EDIT_CLEAR. The equivalent of pressing the delete key.
Cheers, Peter -----Original Message----- From: Simmonds, Ashley (PTB) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 11 September 2002 1:25 PM To: 'Mapinfo List (E-mail)' Subject: MI-L SQL delete is there such a thing as SQL delete commands in MapInfo? the closest i can find is one where you can delete rows/objects from a table based on ROWID. eg. delete object from mytable where rowid = myrow however i want to do something like... delete object from mytable where myfield.value = myvalue but there doesn't seem to be a way to do it. the best i can do is do an SQL select, put all the relevant ROWID's into an array, then run the former SQL delete for each selected object. i'd like to do it in one hit, rather than have to make up a loop to do it. ash
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2961