SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
multiple triggers

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
multiple triggers
Author Message
Scott



Joined: 20 Feb 2002
Posts: 2

Post multiple triggers Reply with quote

Can I have multiple triggers for a table in database? What I would I would like to do is monitor changes for on application selectively and all changes from any other application.

Tue May 16, 2006 12:49 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Re: multiple triggers Reply with quote

Yes you can do both.

: Can I have multiple triggers for a table in database? What I would I would
: like to do is monitor changes for on application selectively and all
: changes from any other application.

Tue May 16, 2006 1:00 pm View user's profile Send private message
Scott



Joined: 20 Feb 2002
Posts: 2

Post Re: multiple triggers Reply with quote

Not to sound to stupid but how would I do this? I've set my triggers for for all applications that monitor my high priority fields. How would I add another trigger that would monitor all changes from all but the one application?

: Yes you can do both.

Tue May 16, 2006 1:06 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Re: multiple triggers Reply with quote

If you are asking about DB Audit, you don't need to worry about all that stuff. You use the GUI and the rest is done automatically for you. If you are asking generic database development questions you are in the wrong place. This message board is dedicated to support of DB Audit, DB Tools and DB Mail products.

: Not to sound to stupid but how would I do this? I've set my triggers for for
: all applications that monitor my high priority fields. How would I add
: another trigger that would monitor all changes from all but the one
: application?

Tue May 16, 2006 1:23 pm View user's profile Send private message
Scott



Joined: 20 Feb 2002
Posts: 2

Post Re: multiple triggers Reply with quote

I am using DB Audit, I just don't see where in the gui that you can specify two sets of criteria for the table. I see how to add or exclude an application for the table. What I don't see is how I would do the following:
monitor a change from my accounting application on a specific field within a table and monitor all fields from the same table from any other application.
: If you are asking about DB Audit, you don't need to worry about all that
: stuff. You use the GUI and the rest is done automatically for you. If you
: are asking generic database development questions you are in the wrong
: place. This message board is dedicated to support of DB Audit, DB Tools
: and DB Mail products.

Tue May 16, 2006 2:51 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Re: multiple triggers Reply with quote

Oh, I see now what you are trying to do. You cannot define multiple auditing tiggers with different filters on the same table becasue DB Audit doesn't support such option. What you can do, is to let it audit both applications, in other words, you can set an "include" filter for these 2 applications only and then create 2 custom reports one for each application. In reports you can select as a criteria which application name to filter on. You can also choose same or different columns for display on each report. Hope this helps.

: I am using DB Audit, I just don't see where in the gui that you can specify
: two sets of criteria for the table. I see how to add or exclude an
: application for the table. What I don't see is how I would do the
: following: monitor a change from my accounting application on a specific
: field within a table and monitor all fields from the same table from any
: other application.

Tue May 16, 2006 3:53 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.