If you don't have an index, VFP will have to scan whole table regardless what you do. DELETE-SQL will be even slower because it'll lock/unlock each record.
>
>I'd like to delete records in all my stage tables which are prior to the certain date. My colleague suggested to use tEntered_Date field (we don't have an index on this field). I wrote a program using DELETE FOR command and it's still running.. (couple of minutes already).
>
>I'm wondering, what should I do to make it quicker?
--sb--