Another method, depending on your application that works very fast .... Project a new table from your old one using only the rows you want to keep
R>Project NewTable from Oldtable using all where .... Then drop the old table.. R>Drop Table OldTable Rename the Newtable to Oldtable Create indexes as in the original. While this may take four lines of code, it often is much faster than the delete command and has the benefit of new, "clean and fast" indexes in the resulting table. -Bob Thompson Technology Consultants 276 Chippewa LaPorte, IN 46350 219-324-2605 (Phone & Fax) 219-363-7441 (Cell) http://ttc.inc.home.comcast.net -----Original Message----- From: Steve Breen [SMTP:[EMAIL PROTECTED] Sent: Tuesday, April 26, 2005 8:08 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Deleting row question David, The second method is faster by far. It seems that the more rows that are deleted the slower it gets. Ran the second option first and it just flew thru the process the second one is running now and it is going to hours. I am just going to have to stop it. Will use the new concept Thanks David and Razzak
