Hi Jaime.
>I have a directory with dbase 3 tables and indexes. I am trying to connect to it from a vfp9 application, but with no success. When i use the dbase 3 odbc connector, it asks for the directory where the data resides. How do i then run calls to this data through the connector? Can it open the tables in share mode? Add new records ( updating old db3 indexes )?
Use a DSNless connection (ie. SQLSTRINGCONNECT) and specify the directory in the connection string:
lnHandle = sqlstringconnect('Driver=Microsoft dBase Driver (*.dbf);dbq=Directory for tables')
Then you can anything you'd like using SQLEXEC(), including adding, editing, or removing records.
Doug