Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DBase and ODBC
Message
De
06/03/2002 10:55:53
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
DBase and ODBC
Divers
Thread ID:
00629032
Message ID:
00629032
Vues:
42
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform