Information générale
Catégorie:
Applications Internet
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement