Hi!
I guess there are no limitation for length of T-SQL commands batch. Just try:
strSQL = replicate("INSERT INTO tmp (tmp) Values(1)"+chr(13)+chr(10),60000)
SQLEXEC(nConnectHandle,strSQL)
And see what happen (in aerror() result).
>Hi, Vlad...
>
>Interesting! I wouldn't have thought of that...one question - at what point would the string size of the entire SQL string exceed system capacity (either within VFP or within SQL Server)?
>
>Thanks for your help and suggestions!
>Kevin
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.