Thanks to both of you. The delete from selection worked. I just realized that I forgot to commit, then pack the table after deleting the selection before, so the second time I ran it, it gave me a "cannot access selection as a table" error. It had found the extra rows, but since they had been deleted the first time, the selection table was empty. But thanks for the advice, you got me back on the right track.
Terry -----Original Message----- From: Uffe Kousgaard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 2:49 PM To: Terrence O'Neill Cc: [EMAIL PROTECTED] Subject: Re: MI-L Deleting selection Hi Terrence select * from table delete from selection If that doesn't work do it this way select * from table into tmp1 delete from tmp1 There is no need to close tmp1 as it closes, when there are no rows left. And now no more answers for tonight ! Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "Terrence O'Neill" <[EMAIL PROTECTED]> To: "'Mapinfo'" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 11:28 PM Subject: MI-L Deleting selection > One quick question. The answers probably something simple, however, it has > been eluding me. Once you've used the select statement in MapBasic to > select certain rows from a table, how do you delete them from the table?? > "Delete From" wipes out all from the table, you can't use a where clause > unless you have the rowid, and I even tried "delete selection from" and, of > course, that didn't work either. Someone please(!) give me a clue. > > Terry > > > > _______________________________________________________________________ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. > _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
