Bypass deleted records

[RichardBarth]

I've finally managed to access Foxpro tables with the OLEDB provider. Using the code:

dim Conn as new adodb.connection
dim rst as new adodb.recordset
conn.provider = "vfpoledb"
conn.open "c:\foxprodata"
rst.open "mytable", Conn, adOpenStatic, adLockOptimistic

The problem I'm having is that the recordset includes all records in the mytabl.dbf file, including all the deleted records. Is there any way I can either identify the deleted records in the recordset or avoid retrieving them?

Thanks for any help you can offer.

 

[Olaf Doschke]

As said in the other thread:

oConn.Execute("SET DELETED ON")

Bye, Olaf.