Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP to Timberline Office JobCost Format Poblems
Message
From
06/11/2006 09:34:15
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
05/11/2006 15:28:57
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
01167207
Message ID:
01167295
Views:
8
>Hi all,
>I am trying to insert records from vfp table into Timberline/Sage/Pervasive database.
>We are able to do this manually in MSAccess. I get field format errors on Job,Status,AR_Customer fields. Apparently these fields have a marker to indicate actual field size. The remote view shows char 10 for Job & AR_Customer. Status indicates char 11.
>
>This is our fourth application for a client who relied heavily on Access/Excel.

A stab in the dark: once upon a time, Turbo Pascal had this habit of prefixing strings on disk with a length byte. So, "good morning" would actually be stored as chr(12)+"good morning". You may try to send those fields as

chr(len(cValue))+cValue

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform