John,

You could write a pretty simple procedure that would use SCATTER/GATHER to take care of all the general fields. Then use AFIELDS() to find any general fields and REPLACE those using macro substitution.


>I have written generic code for archiving data from a live database to an archive database using views and the Scatter/Gather commands. I recently added a table that contains a General Field. As the VFP documentation states, Scatter and Gather do not work with General Fields.
>
>Does anybody have a slick approach or method for copying records from one table to another table (with duplicate structures) when the table has a General Field in it?
>
>Thanks for any help you might be able to give!
>
>John