>Hi there,
>
>I have a program that uses scatter/gather. When it gathers the records from a table, there are several fields that get overwritten in the table that the fields are being updated to. These fields don't exist in the table that I am appending from. Is there a way to omit certain fields from being gathered when using that method. I know that I can gather only certain fields, but is there a way to omit certain fields also.
>
>Thanks,
>
>Jolene
You can do SCATTER FIELDS EXCEPT ....
But, if like you say, the fields getting overwritten in the GATHERing table are not in the SCATTERing table, then then problem is that you SCATTERed these fields to memvar at some point earlier in the code and they are still in memory. GATHERing at that point will still pull in all existing memvars that match fields. Make sense?
HTH
Insanity: Doing the same thing over and over and expecting different results.