Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sending long SQL statements to VFP via OLEDB
Message
From
15/11/2001 16:41:26
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Sending long SQL statements to VFP via OLEDB
Miscellaneous
Thread ID:
00582403
Message ID:
00582403
Views:
49
I am writing a web application that uses VFP 7 as a data store, and am running into a problem inserting large records into my database.

Whenever a user types large amounts of text into something like a comment field, I'll get the error:

Microsoft OLE DB Provider for Visual FoxPro error '80040e14'
Command contains unrecognized phrase/keyword.

I know that I could just create a small record (unique id only) and then do multiple updates to get all the info into my database, but am hoping that someone know how to get VFP to just accept a long (> 255 char) SQL Insert string.

Any ideas? Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform