Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC & Clipper dbf files
Message
From
25/06/1998 13:32:23
Dave Nantais
Light speed database solutions
Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00111502
Message ID:
00111632
Views:
16
>>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
>
>Becky, Dave has offered one approach. However, IF you have the Clipper source code, you can recompile the program so it uses CDX indexes and FPT memo file structure as if the Clipper program were written in Fox2.x. Then you treat the Clipper tables as Fox free tables and VFP works beautifully.
>
>Clipper 5.2 and 5.3 have the drivers built in - you just set a switch. Older versions of Clipper use add-on drivers. I used the Six-Driver pack and it worked like a charm. It came with a program to convert your existing data to the new format.
>
>HTH
>Barbara

My solutions assumes you cannot change the clipper program in any way.

If you can change the clipper program then my approach is more work than Barbara's method and the data access performance will be better with Barbara's method.
:)

IMHO
CDX files are what set FOX apart from the rest of the xBase crowd.
:)
HTH,
Dave.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform