Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Add Date/Time stamp to tables in dbc.
Is there an easy or preferred way to maintain a date/time stamp field in a table (in a dbc)? I want to record the last date/time that a record is modified (which includes a delete). All my tables already have a date/time field and I do have a default value coming in when a record is added, but I need it updated whenever the record changes & I'm not sure where the best place to put this is. I'm thinking that it's better to be in the dbc as a record validation rule, but I'm already using those on many tables. I hate to write a ton of procedures to call two validation rules, but I will if I have to. The only alternative I can think of is to add the code to the class for the save push button, but for some reason I'm thinking that's not the cleanest and safest way to manage it. Any suggestions or tips?
TIA, Susan
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