>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
>
I guess you mean: SELECT m1+m2
AS mResult FROM test INTO CURSOR cResult
The maximum # of characters per table field is 254. Yours is 600. This causes the ERROR (it's not a bug!).
You'll have to find another solution.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.