General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only