>Hi,
>
>within a SELECT-SQL command,
>i need sum two memo field into one memo field.
>
>I can make it?
>
>Example:
>

>CREATE CURSOR test;
>  (m1 M DEFAULT REPLICATE('X',300);
>  ,m2 M DEFAULT REPLICATE('Y',300))
>
>APPEND BLANK
>
>SELECT m1+m2 mResult FROM test INTO CURSOR cResult
>
>* report : Error 1903 : String is too long to fit
>

>
>Fabio

Hi Fabio,
this seems a nice one. I tested that with a cursoradapter, setting CURSORSCHEMA='mResult M'
If I do CURSORFILL(,.t.) (NoDataOnLoad) it creates a cursor. DISPLAY STRUCTURE shows that the FieldType is memo
If I try to CURSORREFRESH() it fails.
If I do CURSORFILL() it fails to.

There is something very strange on it.

Agnes