Information générale
Titre:
Max Length of SQL Pass-through string
A newbie here trying to use SQL pass-through to SQL Server 2000 with VFP7.
I got it working, but there seems to be a 270 character max length to the string that I include in the SQLExec(hConn, "CREATE TABLE PTEST (field list....)") command. I get an invalid command error message when the string get to long.
Is there a VFP setting to increase this length that I am overlooking?
The workaround, of course, is to create and "SQLExec" a stored procedure, which is what I did. However, it would be nice to know if the 270 or so characters is a real limit or not -- and if not what is the max limit -- and where can that be set (further I would expect the limit to be 255 not 270).
Puzzled here in Paradise -- and thanks in advance for any help.
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