Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC and VFP Char string limit
Message
From
02/09/1999 17:36:58
 
 
To
02/09/1999 15:00:26
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00260778
Message ID:
00260870
Views:
17
Hi Eugene,

It's an ODBC limit. Anytime you have a command larger than 254 characters, it goes poo-poo. This is with SPT....remote views seem to (almost) always work OK. Split up your commands as well as you can.


>I am getting an unrecognized command/keyword error when trying to INSERT into a VFP ODBC data source where the length of one the strings is greater than 255. The VFP data source has a MEMO field so I assume that it is not a DBF problem. It appears to be a limit on VFP commands or more likely the ODBC driver itself.
>
>Any information may be helpful.
>
>Thank you,
>
>Eugene Elder
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform