Steve,
You're welcome.
>The issue was not with scatter/gather.
Yes, I know, I was simply saying I prefer SCATTER NAME over SCATTER MEMVAR for doing this type of operation.
>I have a routine that exports data in the form of a free table. I use a SELECT-Sql to create my free table. That is truncating my field names to 10 charachters. SO when I go to scatter/gather, they arent getting populated, the field names dont match up. The exported table needs to remain free.
>
>Any solutions, other than renaming all my fields?
Are there a lot of fields? Do the field names change? If they don't change, you can use a REPLACE statement for those fields that are not working with SCATTER/GATHER.
If the fields on the two tables are in the same order, you can use SCATTER TO array...then the field names themselves don't matter.
HTH,
Steve Gibson