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.
