>Please give more details.
>Thank you
>Chaim

ie:

Your scatter/gather might look like :

select Source
scan for SomeExpression
 scatter memvar memo
 insert into Target from memvar
endscan

Could be written as :

select Target
append from Source for SomeExpression

*or
select f1 as myF1, f2 as myF2,... from mySource into array arrMyArray
select Target
append from array arrMyArray

*or
select source
copy to array arrMyArray for SomeExpression
insert into Target from array arrMyArray 

*or
select source
copy to array arrMyArray for SomeExpression
select Target
append from array arrMyArray

VFP8 has greater control :

* Sample 1: Using scatter name
select Source
scan for SomeExpression
 scatter name objRecord memo
 objRecord.myField = objRecord.myField * 2 && Change a field value
 insert into Target from name objRecord
endscan

* Sample 2: Using insert into ... select ...
insert into Target  ;
  select *, AdditionalExpr as myAdditonalField ;
  from Source ;
  where SomeExpression

Cetin