Hi!

As far as I know, this is very depended on the ODBC driver and a kind of the command you going to send.

Just test it. Something like following in command window (for SQL Server):

nn = SQLStringConnect(...)
=SQLEXEC(nn,"CREATE TABLE ttt (ttt int)")
strSQL = replicate("INSERT INTO ttt values (2)",5000)
=SQLEXEC(nn,strSQL)
=SQLEXEC(nn,"select count(*) as cnt from ttt",ttt)
sele ttt
brow last
NumChars = ttt.cnt*len(("INSERT INTO ttt values (2)")
? NumChars

HTH.



>I have experienced an apparent limit of 255 chars length for the text within a SQLEXEC() command? Any Ideas as to what is going on? I thought the limit was supposed to be about 64K.
>
>Many thanks for any inputs
>
>Dick Balluff
>RLB Associates
>can be reached here or via rlb@surewest.net
>(916)789-8855