Hi I am trying to move records from one table to another. The following code works for all tables except tables with general fields in them. (The new vs. old tables all have the same structures)

**************************************
SCATTER TO x MEMO
INSERT INTO (newtable) FROM ARRAY x
**************************************

If there is a general field in the table the above code will move all the remaining columns one column over for where they belong, + it does not copy the Generalfield over.

I know I can insert a general field with the following code,

*********************************************************************
INSERT INTO newtable(generalfield) VALUES (oldtable.generalfield)

*********************************************************************

but was hoping there would be a cleaner solution.

Please give me your thoughts.

Thank you, Cicilia