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.