select Source scan for SomeExpression scatter memvar memo insert into Target from memvar endscanCould 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 arrMyArrayVFP8 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 SomeExpressionCetin