Hi Sergey,

I wasn't sure how to pass the SET DELETED OFF to the driver.

Thanks,
Gavin.

>Gavin,
>
>You can use SET DELETE OFF command. For example,

lcConStr = "Provider=vfpoledb;Data Source="+HOME(2)+"northwind\northwind.dbc"
>oCon = CreateObject("ADODB.connection")
>oCmd = CreateObject("ADODB.Command")
>oRs  = CreateObject("ADODB.RecordSet")
>oCon.Open(lcConStr)
>oCmd.ActiveConnection = oCon
>oRs.ActiveConnection = oCon
>oCmd.CommandText = [SET DELETE OFF]
>oCmd.Execute()
>oCmd.CommandText = [ SELECT  SET("DELETED"), * FROM orders]
>oRs.Source = oCmd
>

>>Hi All,
>>
>>How do you select deleted records using the OLEDB Driver. I've done a:
>>
>>

>>SELECT * ;
>>    FROM mytable ;
>>    WHERE DELETED()
>>

>>
>>but I get no records returned even though there are deleted records in the table.