altering .cdx indices for vfp

[Bernie Yaeger]

My client has a visual foxpro app that he wants me to hook into. I'm
connecting to it via odbc using visual basic .net with this
connectionstring:
Dim oconn_d As New OdbcConnection("Driver={Microsoft Visual FoxPro
Driver};SourceType=DBF;SourceDB=c:\test;exclusive=NO")

These are free standing tables, all with .cdx files. I do not own nor do I
intend to use vfp to work with this; rather, I am working with it
exclusively inside vb .net. To display data, I have no problems; however,
if he wants me to modify data, this requires altering the .cdx, which
probably happens automatically using vfp, but not with odbc. What can I do
to update .cdx files when accessing them via odbc?

Tx for any help.

Bernie Yaeger

 

[Guest]

Use sql commands. Google sql for help.

I hope that helps,
Olice