Information générale
Catégorie:
Codage, syntaxe et commandes
Hi everyone:
Is there an easy way to note the changes in a table to another table without listing old values and new values for every field in the original table? Right now, when someone makes a change to a table, a trigger saves the old values for each field and the new values for each field to a new table. What I would like is a way to know which field changed and only have the old and new values for that field stored to a table (in other words, the table that stores the old and new values would only be 2 columns)
Any suggestions? Thanks.
Paul
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