Just curious,

What happens if you use NAME instead? for example, something like:

SELECT (mysourcetable)
SCATTER NAME orecord

SELECT (mydestinationtable)
APPEND BLANK
GATHER NAME orecord
RELEASE orecord

Do you get the same result (the same fields do not get saved to the destination table everytime)? It is strange that the same fields do not copy over -- they are not the lasts fields in the table are they? Otherwise, that is very suspicious and I would suspect they are not identical at all...

>Thanks for the quick resposne!
>
>To answer your questions:
>
>1. In both the Database Table and Free Table the NULL check box for all fields is unchecked.
>
>2. From what I can tell it is always the same fields that drop off, short field names - 10 char or less (same field name, type, & length in both Database Table and Free Table).
>
>3. Never anything dropping off on the long field names due to the necessary REPLACE statements I've added.
>
>4. The code at the bottom of the original post is basically what's in my program except I have many more REPLACE statement becuase their are quite a few long field names.
>
>I though of ditching scatter/gather and going with 250 REPLACE statements but I'm trying to avoid poor techniques.
>
>Regards,
>Torrey