I'm betting he does! < s >

cheers


>Hi Sergey,
>
>I don't suppose you'd know how to select deleted records from a FoxPro DBF in VB.NET?
>
>Regards,
>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.