Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBase and ODBC
Message
From
06/03/2002 10:55:53
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
DBase and ODBC
Miscellaneous
Thread ID:
00629032
Message ID:
00629032
Views:
46
I have a situation at a client in which they are running a software system called Cougar Mountain (accounting). According to the vendor, the data files are in dBase IV. I don't want to convert any of the data over to VFP. I just want to modify the data. It seems that when you access the data directly, it creates a vfp compound index file. This is fine since it doesn't cause any problems with their software. The problem arises when you access the dbase IV files directly and it has a memo field. VFP wants to convert it over and will not use the table unless the memo file is converted over. Needless to say, that would cause a problem for their software. The next path I took was to use the dbase IV odbc driver. This isn't working either. It seems that data is being lost. Not records but fields. Alot of the fields are being passed back via spt and they are showing .null. I have verified that the data is there and it is not .null. Any ideas on what is going on and how to fix it so that I can keep this client happy? (besides rewriting an entire accounting package in VFP...I tried that already! *GRIN*)

Thanks,
pat.
Patrick L. Stovall
Senior Architect/Developer
MCP - C#

VeroQuest
P.O.Box 7216
Kalispell, MT 59904
Next
Reply
Map
View

Click here to load this message in the networking platform