>>>8192 is VFP statement size limit. SQL Server Length of a string containing SQL statements (batch size) = 65,536 * Network packet size (default 4k) = 64k*4k
>>
>>This explains some things. I understand now why SQL Server does not give an error. But I am wondering how come I create a SQL Select string in VFP of greater than 8192 and I don't get an error. Unless I misunderstood the "8192 VFP statement size limit"
>
>8192 is max # of characters per VFP command line. A string size limit is about 16MB or more depending how you will use it.
Now I see. In this case, I don't think I have a problem with the initial question that I started this thread.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham