>Peter
>I'm having a problemn with the lengths of the SelectCmd and the UpdateNameList properties of some CursorAdapters.
>It seems that the maximun lengths is 255 characters. But I also read in Mark Casland CursorAdapter builder that this limitation NO LONGER EXISTS.
>
>*!* There was a known issue with a limitation in the Property sheet
>*!* which only allowed the display of a maximum of 255 characters.
>*!* This was particularly annoying for properties like CursorSchema
>*!* because without information in the CursorSchema property, you
>*!* could not drag fields from the cursor and drop them onto a form.
>*!* This limitation of the Property Sheet NO LONGER EXISTS.
>
>Seeing this mail it seems you had the same problemn.
>Is there a workaround for this?
>Hernan

Hernan,
Yes there is limit IF you store the values of these properties in Properties window. BUT if you put in Init event of the CA:

TEXT TO this.SelectCmd NOSHOW PRETEXT 15 TEXTMERGE
     SELECT .....
            FROM ....
            <joins here>
            <WHERE>
ENDTEXT

You could store much more than 255 chars in that property.