Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Moving records with General fields
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement