Connecting Foxpro 2.6 dbf with ADO

[vijayd]

I have connected a forxpro 2.6 dbf file using ADO in my VB Project. It also works fine. However, it returns all the records including records which are marked as deleted in the dbf file. How to exclude these deleted records ? Pls. help.

Rgds.

Vijay
:(

[BsCis99]

vijayd: I have connected a forxpro 2.6 dbf file using ADO in my VB Project. It also works fine. However, it returns all the records including records which are marked as deleted in the dbf file. How to exclude these deleted records ? Pls. help.

BsCis99: FoxPro has a SET DELETED ON/OFF setting that determines whether or not records flagged as deleted (but not yet physically eliminated from the table via a PACK command) are accessible. The default is OFF, which means that deleted records are visible. You need deleted to be set ON.

I am assuming that you are accessing FoxPro in ADO via ODBC. Somewhere in the ODBC setup wizard -- possibly reachable only by clicking some kind of an ADVANCED OPTIONS button -- there should be a checkbox that says []DELETED (or something like that). Set it to the opposite value of what it currently has, then try again.