General information
Category:
Internet applications
Title:
Sending long SQL statements to VFP via OLEDB
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only