> In my table, I have 2 memo fields. Let say MEMO1 and MEMO2. I would like to
> do something like this in my SQL:
>
> SELECT MEMO1+MEMO2 FROM mytable...
>
> But, this gives "String is too long to fit". Any workaround for that?
Couple of, but you won't like it :)
#1: Select them both, then reopen the cursor (classical Use (dbf())
again alias newcurs), and Replace All memo1 with memo1+memo2
#2: Select none, but add record number:
select this, that, recno() as rcn from ...
set order to 0 in source_table
set rela to rcn into source_table_alias
This is somewhat quicker, since you don't really Select the memos, and
you probably don't need all of the memos all of the time. If that is the
case, you can always do something like
dummy_memo=original.memo1+original.memo2
while processing a single record. If you really need all of them at
once, this may not be the best.