Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>We recently added a "last modified" field to all of our tables in our database for time-stamping purposes in case we need to resynchronize data records as of a certain point in time. What we would like to do is populate this field with DATETIME() whenever the corresponding record gets updated. These tables already have an update trigger defined.
>
>Is there a way to accomplish this that doesn't result in illegal recursion within the trigger?
Don't. The datetimes() are for each local clients, and you will get problems with clocks slightly off.
go for numeric or currency field incremented from a master table if connected / not road warrior,
add flag notice if running disconnected. get a hint from MS-SQL implementation of rowversion().
Précédent
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