>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, this SELECT statement is creating a char field mResult of more than 254 char length. Hence the error. I do not think this is a bug. One could perhaps argue that the result of concatenating the two memo fields should result in a new memo field?
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.