>>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.
--sb--