Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with DBF CHAR field in VB 6
Message
From
18/04/2006 14:22:32
Larry Huisingh
Lockheed Martin Information Technology
Richland, Washington, United States
 
 
To
18/04/2006 13:05:24
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
01114318
Message ID:
01114352
Views:
13
Only because nobody knows any better around here. Accessing legacy DBF files in VB6 or newer is considered a "black art" that not many people have done and if they have done it they don't remember how it worked. I have been a FP developer for years but have no experience with accessing the files via VB. Do you have any code snippets we could use? Our developer was using the following:

Set dbsCurrent = DBEngine.Workspaces(0).OpenDatabase(sDataFilePath, _
False, False, "dBase III;")
Set rsData = dbsCurrent.OpenRecordset(sFile)

where sDataFilePath is the folder name and sFile is the file name.

Larry

>Why are you using the dBase III ODBC driver instead of the VFP ODBC driver or even better, the VFP OLEDB Provider?
>
Larry Huisingh
Lockheed Martin Information Technology
Richland WA USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform