>>>Hello,
>>>
>>>I'm using FP 2.6 and VFP 6.0, I'm using SQL quite a lot and have a question about it :
>>>
>>>Is there a limit to the length of a SELECT- SQL statement in VFP 6.0 and in FP 2.6 ?
>>>
>>>Thank you in advance.
>>
>>In FP2.6, the limit is 2K characters.
>>
>>In VFP 5, this went up to 8K characters, but I'm not sure if it went up again for VFP 6 (I don't think so).
>
>There was a post about the limit on the RowSource part being 255 characters (VFP5). It should be around early November. Not being sure here, pls be advised to check it out yourself.
I would guess that you wouldn't be able to enter more than 255 characters as a ROWSOURCE in the properties window, but you should be able to enter more by coding in the objects init method e.g.
THIS.RowSource = "SELECT ..........." && to theoretical 8k limit