Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Network:
Windows 2008 Server
The place I work we use the triggers in MSSQL to notify other users of changes that take place. In MSSQL I created a table named HotList. This table holds a userid, short description, notes field and a few other misc. fields. When we have a problem with an item and it falls into the criteria for the trigger, an item is added to the users HotList. This lets the user know what’s wrong and when it happened.
Pit fall, you have to write a HotList form for the application and do not allow the users to close it. Then set a refresh timer on the form to update the data in the grid.
Not sure if that helps you or not, but it’s the way we handle it.
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