Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Saving field level changes to a table
Anyone have any good ideas on saving changes made to certain fields to a table every time the value of the field is changed?
I want to use field level triggers in the fields I want to capture, within the tables in the DBC, to save every time the value of that field changes. I would like to save the change to another table that has same field structure as the field being changed. I don't want to save the change to a memo file, it's a pain if I need to research and I can't quickly add the value back to the original table.
Is there a discussion on this subject somewhere out on the thread?
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