>I am havina problem using gather. I am trying to copy a record with over a hundred fields and 1 memo field. Therefore I:
>
>
>scatter memvar
>SCATTER FIELDS LIKE fabwearcom TO memo
>
>
>But when gathering I do:
>
>append blank
>gather memvar
>
>
>How do I gather the memo field I have tried GATHER fields like fabwearcom MEMO but this doesnt work! Any help would be greatly appreciated.
>
>Many thanks
scatter memvar
mMyMemo = ALLTRIM(MemoField)
append blank
gather memvar
REPLACE MemoField WITH mMyMemo
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.