der, of course, just delete the newly created query. i'm sure i've done exactly that in other circumstances, today it just didn't occur to me.
as for Edit, Clear (delete key, runmenucommand 205), that's what i'm trying to avoid, as for some reason it sometimes works and sometimes doesn't depending on the focus of my form, speed of the query, number of other simultaneous functions, or whether it just feels like it. anyway, i've found such things as cut,copy,paste,delete and various other native windows features to be very unreliable, so i'm eventually making analagous custom procedures to account for all of these things. thanks. ash -----Original Message----- From: Taylor, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 11 September 2002 1:27 PM To: Simmonds Ashley (PTB) Subject: Re: MI-L SQL delete Hi Ash You've fairly much got it I do a select into a named query then delete the query eg: select * from bigtable where field = "nonsense" into delme delete from delme This get rid of the complete feature attributes and all, whereas select * from bigtable where field = "nonsense" into delme delete object from delme will only remove the map objects from the table while leaving the attributes Regards -- Mike Taylor ______________________________________________ GIS Senior Consultant mailto:[EMAIL PROTECTED] Sinclair Knight Merz Limited http:\\www.skmconsulting.com Level 12, Mayfair House Tel: +64 4 473 4265 54 The Terrace Fax: +64 4 473 3369 PO Box 10283,Wellington New Zealand NOTICE: This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action in reliance on it. If you have received this message in error please notify Sinclair Knight Merz Ltd immediately. Any views expressed in this message are those of the individual sender, except where the sender has the authority to issue and specifically states them to be the views of Sinclair Knight Merz. The recipient is responsible for reviewing the status of the transferred information and should advise Sinclair Knight Merz immediately upon receipt of any discrepancy. The sender makes no warranty regarding the presence of electronic or magnetic data errors or computer viruses, or as to the accuracy or completeness of the data transmitted. -----Original Message----- From: Peter Zyczynski [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 11 September 2002 1:33 PM To: 'Simmonds, Ashley (PTB)'; 'Mapinfo List (E-mail)' Subject: RE: MI-L SQL delete 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 12:55 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: 2962