Hi Gavin.
Yep, I can process it OK but I needed a generic solution to structure modifucation.

Dang! You know, it doesn't even work if you modify the structure of a table! I'm sure it used to. More grey hairs...
Dang dang dang

:-)


>

Hi Dave,
>
>   I had the same problem a while back.
>
>   To get around it I did something like:
>
>SELECT filewithmemo
>
>SCAN
>   SCATTER MEMVAR MEMO
>   INSERT INTO filewithoutmemo FROM MEMVAR
>ENDSCAN
>
>Hope this helps,
>Gavin...
>

>
>>Have I have been deluding myself for years?
>>
>>If I APPEND FROM from a table which has a memo field named MyNotes into a table with a character field named MyNotes, ought not the contents of MyNotes be transferred from the memo field into the character field, or at least as much as will fit?