Creating an AFTER AFTER trigger
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Date: Thu, 13 Jan 2005 12:01:32 -0500
i want a trigger to fire after the data modification has been applied to the
database - so that a view i query from contains the new values.
Possible?
Short of having the trigger start a scheduled task.
Relevant Pages
- Re: Error 2950 - Reserved Error on form refresh/requery
... and I can't leave the client with an unusable database while I try to ... The requery is on the form (so the data displayed in the sub-forms refreshes ... The triggering event is a listbox after update that does 2 things only: ... can trigger others, and so the problem may occur only when a specific ...
(microsoft.public.access.formscoding) - Re: Help with INSERT TRIGGER - fails with error.
... You didn't declare any PRIMARY KEY in this database. ... In an INSERT trigger, ... but I can't get it to work because it references ntext fields. ...
(comp.databases.ms-sqlserver) - distributed query runs indefinitely
... I am trying to complete a distributed query on two seperate sql instances, ... one database to the other when an insert occurs in the originating database. ... I have attempted both a trigger running the sql query and a trigger calling a ...
(microsoft.public.sqlserver.replication) - Re: Lookup Tables, the right way?
... model is comes in un-learning what you know about file systems. ... The users might not all have the same database access rights ... This rule would be enforce by a REFERENCES ... with a trigger that you can do with DRI and more. ...
(comp.databases.theory) - Re: Using one table vs. many
... model is comes in un-learning what you know about file systems. ... The users might not all have the same database access rights ... This rule would be enforce by a REFERENCES ... with a trigger that you can do with DRI and more. ...
(comp.databases) |
|
