Hi Larry,

That's what I needed thanks alot.
Somehow I could not find that info in the MSDN.

Doron

>Maximum # of characters per command line 8,192
>Maximum fields that can be selected by a SQL SELECT statement 255
>
>If you are simply creating a SQL statement like select MySuperLongFieldList from MySuperlongTableList where MySuperLongWhereClause then you are limited to the above.
>
>Check out MSDN under Visual Tools and Languages - Microsoft Visual FoxPro 7.0 - Reference - General Reference - Visual FoxPro System Capactities.
>
>HTH.
>
>>Well I am running an SQL statement with 4148 characters as of now.
>>I am looking to know what is the limit?
>>
>>>right, if you read the whole thread you'll see that was what we were saying.
>>>In may case, I have written twice as much more that 225 with no problem
>>>
>>>
>>>>Hi There,
>>>>
>>>>I looked at that thread but what I need is to know the maximum size
>>>>of the SQL statement that can be exexcted within a prg file.
>>>>
>>>>In other words how many characters can be within sql statement, it is much
>>>>more then 225 characters as mentioned in that thread.
>>>>
>>>>Thanks,
>>>>
>>>>Doron
>>>>
>>>>
>>>>
>>>>>see Thread #556564
>>>>>
>>>>>>Hi All,
>>>>>>
>>>>>>What is the maximum SQL string that can be executed in VFP 6 and
>>>>>>VFP 7.
>>>>>>
>>>>>>Thanks,
>>>>>>
>>>>>>Doron