John;
Too bad, I guess having records 'marked' for deletion as is done is DBF files is not accounted for by ADO. The command I will use is:
SELECT *, DELETED() AS DeleteIt ...
It allows for a single recordset but a recordset property would be preferred.
>My guess is that you would not find this item in the extended properties of the Recordset. One thing to keep in mind, this is a fabricated recordset - which means it exists indepdendent of a connection. And for this reason, I would almost bet the ranch and dog that you could not tell.
>
>But here is a quick workaround that gets the job done...
>
>
>Set deleted off
>select deleted() as del,* from customers into cursor foo
>ors = createobject("adodb.recordset")
>ovfpcom = createobject("vfpcom.comutil")
>ovfpcom.cursortors(ors,"foo")
>
George