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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.