Information générale
Titre:
Long Insert string fails using odbc
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
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