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