Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

table trigger?

Status
Not open for further replies.
blkm74

blkm74

Programmer
Jul 23, 2002
11
MO
Can I define more than one procedure/function in table insert trigger?

Thanks!
 
Sort by date Sort by votes
even through you are only allowed to define one procedure, I guess could call procedures that are defined out side the trigger. Attitude is Everything
 
Upvote 0 Downvote
Well yes and no! <g> For the trigger you can only specify a logical expression, but it can be complex. e.g. I've used:
security_check() AND __ri_insert_users()

Where both stored procedures (actually functions) return T or F.

Rick
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Rajesh Karunakaran
  • Locked
  • Question
Timer doesn't trigger when run under Windows Task Scheduler
Replies
7
Views
713
ggreen61
ggreen61
trial03
  • Locked
  • Question
excel pivot table with XML data source
Replies
1
Views
371
Chriss Miller
C
SitesMasstec
  • Locked
  • Solved
Copy fields from one table to another
2
Replies
26
Views
2K
SitesMasstec
SitesMasstec
Mandy_crw
  • Locked
  • Question
What is the correct or best approach in editing a table? 7
Replies
17
Views
2K
Chriss Miller
C
Filip Brnic
  • Locked
  • Question
Using 1 table in 2 different forms
2
Replies
31
Views
3K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top