Help with odbc connection to Foxpro 2.6 (URGENT) 2

[mkua001]

hi;
I am not very familiar with foxpro database. I am doing some development that involve connecting to foxpro 2.6 using odbc to read, insert and update records.

I have no problem programming my asp pages to read, insert and update the tables in the database. And i know that it is writing the data into the database.

Currently the database is also updated by another foxpro application (the legacy system). This application cannot read any of the records that my asp pages had inserted into the same database. Could this be an indexing problem? because i could update a record that the foxpro appliacaiton inserted and the application can read the updated values.

I know that some of the table in that database has the index file .cdx. Do i need to do special commands through obdc to reindex once i have inserted into the database?

Could please anyone tell me what i am doing wrong?

 

[JRB-Bldr]

Perhaps someone else might have an answer for you, but you also might want to consider posting your question on the ODBC forum forum706

Good Luck,
jrbbldr
jrbbldr@yahoo.com

 

[DSummZZZ]

Chances are that since the data is getting updated but yet the legacy app is unable to read the new records, the index is not getting updated. I am not very experienced with the usage of ODBC on Fox tables, but if your ODBC connection is not explicitly opening the index files then they are not getting updated and therefore will be out of synch with the tables. This applies to a record already on the system in which you update with your asp code, that may change the index order.
If you are unable to open that index files you may need to create a routine to reindex them using Fox, or add new records to a separate table and import them into the legacy tables.

Dave S.

 

[mkua001]

Thanks for the help. i really appreciate the help

 

[g3r]

how do i open a cdx file? i tried using the "USE" command but it didn't work.

 

[rgbean]

A CDX index file is automatically opened when the table (.DBF) of the same name is USEd.

Rick