It is not about having a clear or vague memory. The code I provided clearly demonstrates that it is NOT the case and VFP itself has it documented.


>Yes, I have a clear memory of that being the case. I think Tamar documented it, in fact.
>
>>>>>Hi,
>>>>>
>>>>>I am storing a long SQL Select string into a property of a form (property name SQL_SELECT). So far, I don't get any errors.
>>>>>But, just in case, what is the max length of the string I could store in a property?
>>>>>
>>>>>TIA
>>>>
>>>>For an SQL select string it is 8192.
>>>
>>>Note that this is the "compiled" length not the text length. I remembered that much -- I forget how to get the compiled length.
>>>
>>>Hank
>>
>>Are you sure it is not the text length but compiled length?
>>
>>

>>CREATE CURSOR mytable (dummy c(10))
>>INSERT INTO mytable VALUES ('a')
>>
>>lcSQL = "Select * from myTable where myTable.Dummy = 'a' INTO CURSOR crsDummy nofilter"
>>lcDummy = space(8192-LEN(m.lcSQL)+1)
>>
>>Select * from myTable where myTable.Dummy = 'a' &lcDummy.INTO CURSOR crsDummy nofilter
>>

>>
>>This fails for me. If I decrease the command line length by changing + 1 to -2 it works.
>>Same happens here:
>>

>>Public oForm
>>
>>oForm = Createobject('MyForm')
>>oForm.Show()
>>
>>Define Class MyForm As Form
>>	Add Object lb As ListBox
>>
>>	Procedure Load
>>		Create Cursor mytable (dummy c(10))
>>		Insert Into mytable Values ('a')
>>	Endproc
>>
>>	Procedure lb.Init
>>		lcSQL = "Select * from myTable where myTable.Dummy = 'a' INTO CURSOR crsDummy nofilter"
>>		lcDummy = Space(8192-Len(m.lcSQL)+1)
>>
>>		This.RowSourceType=3
>>		This.RowSource = "Select * from myTable where myTable.Dummy = 'a' "+m.lcDummy+"INTO CURSOR crsDummy nofilter"
>>	Endproc
>>Enddefine
>>

>>
>>I am pretty sure in both cases compiled length would be much shorter if it didn't deny to compile.