Hi Brian,

Did I goof up the DeleteCmd in my builder for over 254 characters?

>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