>vfp 3.0 in win 95
>
>I have posted many messages about problems with
>insert & replace creating 2 records. I recently
>read something that said using odbc drivers helps
>when using dbf files from other progs. ie dbase, etc.
>
>Has anyone had this experience? Can using odbc with
>these kinds of dbf files help?
>
>Thanks and have a good day.
>
>Becky
I have had TOO much experience in this area!
If you wish to access a clipper .dbf that is indexed with .ntx indexes AND another clipper program will use those .ntx indexes then you should create an ODBC connection to that clipper dbf
the only problem is : there are no clipper ODBC drivers provided with VFP.
You have to go to a company called "InterSolv" .... "
www.intersolv.com"
They have clipper ODBC drivers for VFP and you get a free 30 day trial
i think they cost $99
when configured correctly they work well but they are slow.
Any querying you should just "USE" the table and open it like it is a fox 2.x table and assume that it has no indexes.
For table changes and additions or deletions you should make an odbc connection and make changes through this connection. And these changes,appends and deletions will be about ten times slower than if they were done in a native foxpro dbf.
Table edits must go through the ODBC connection to maintain the integrity of the NTX indexes.
NEVER index the table with .cdx AND .ntx indexes
Choose one or the other.
check out
http://www.intersolv.com/datadirect/frameset_datadirect.htmlHTH,
Dave