Thank you Brian,
I will use toyr recomentation. Unfortunetely I learned the problem the hard way, because this behaviour is not documented.
Dimitris
>Hi Dimitris,
>
>If you look at Mark McCasland's caBuilder results, you'll see that he textmerges into a variable first, strips the CRLFs, then assigns it to the CursorSchema property.
>
>Try the following:
>
>
>#DEFINE VFP_CRLF CHR(13) + CHR(10)
>
>LOCAL lcSchema
>lcSchema = ""
>
>TEXT TO lcSchema NOSHOW PRETEXT 2
> EMZ55AADR1 C(40),
> EMZ55AADR2 C(40)
>ENDTEXT
>
>lcSchema = STRTRAN(lcSchema, VFP_CRLF, [ ])
>
>This.CursorSchema = lcSchema
>
>
>
>Unfortunately the DeleteCmd property doesn't get built this way, so tables with long names, long field names and multi-field keys easily exceed the 254 char limit.
>
>
>- Brian