>>I have a SQL statement that filters into a cursor.
>>The cursor brings in all of the records (as desired) but, it doesn't carry over the delete marks from the original table.
>>Is there a way to bring the delete marks over, while using SQL SELECT?
>>
>>Thanks in advance!
>
>IMNSHO, deleted records should be considered deleted, gone, discarded.
>
>If you need to use "deleted" records for any reason, you should use a separate field, with some sort of mark, which is under your control - and, normally, filter to show only records that do not have the mark.
Thanks Hilmar. I needed to bring back "deleted" records for the purposes of historical data. The new field worked very well.
Thanks,
Chad