Foxpro FPD DBF Open Issues

0
votes

I am currently developing an integration in C# to talk with an old Foxpro system.

The purpose of this software in reporting & auditing.

I am have following issue when connecting with FPD using ODBC.

  1. I am unable to open shared file (If file being opened any where else)
  2. I am unable to see rows marked for deletion.
1
foxprodbf
The commands SET EXCLUSIVE OFF and SET DELETED OFF come to mind - stuartd

1 Answers

1
votes

Using C#, I would skip ODBC, but instead use VFP OleDB Provider download here

Then, you can create a connection -- connect to the PATH where the table(s) are located, not a connection to the specific table. Then, create OleDbCommand object and send your SQL-Select, Insert, Update, Delete. DO PARAMETERIZED queries to prevent problems.

I have offered many answers associated with VFP, OleDb, C# connection, query, updates, etc so you can easily find many other options from there.