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.
is there a way to use odbc to link to the index file or write sql to update the index?
any help with this problem would be really appreciated...
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.
is there a way to use odbc to link to the index file or write sql to update the index?
any help with this problem would be really appreciated...