Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Long Insert string fails using odbc
Message
De
02/08/2001 20:10:11
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Long Insert string fails using odbc
Divers
Thread ID:
00539168
Message ID:
00539168
Vues:
40
I am attempting to insert into a VFP table from Visual Basic. The insert statement is over 2200 bytes long and it results in a syntax error. When I paste the same statement into VFP command window, I get "Unrecognized command".

The insert works from VB if I keep the statement down to <512 bytes (by not including all the fields).

One of the fields is a memo memo field. When I try to do an update-sql to just that field, if the string is longer than 512 bytes, it fails with "unrecognized command ... " error. I shrink the data down to 511 bytes or so, and the update takes place just fine.

What's going on?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform