Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sending long SQL statements to VFP via OLEDB
Message
De
15/11/2001 16:41:26
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Titre:
Sending long SQL statements to VFP via OLEDB
Divers
Thread ID:
00582403
Message ID:
00582403
Vues:
50
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
Fil
Voir

Click here to load this message in the networking platform