Query to return only records marked for deletion

[mp9]

This is no doubt obvious and easy, so apologies in advance.

I'm using VFP5 and need to query a table and ONLY return those records marked for deletion. How can I do this?

Thanks.

 

[Mike Gagnon]

select * from myTable where DELETED() into mycursor

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[Mike Gagnon]

Of course you would put SET DELETED OFF first, to be able to see the deleted records.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[alvechurchdata]

select * from myTable where DELETED() into mycursor

An index on DELETED() might make this query run faster. Doesn't always work but it's worth a try.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Olaf Doschke]

How about using that index in a scan-loop?

set deleted off
select 0
use myTable in 0 order xDeleted && or whatever you call the index tag
set key to .T.
scan
   ...
endscan

* or a simple
scan for deleted()
...
endscan

Bye, Olaf.