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!

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

Reports Trigger

Status
Not open for further replies.

ni2uk

Programmer
Mar 4, 2002
1
GB
Hi guys,

I m trying to instert record from report to table, so i have written After report trigger in tht i have used srw.do_sql.
On paramenter form there is a user parameter for Insert Y or N.
And then i m cheacking tht flag in trigger.
So the problem is even if the flag is Y, the trigger is not firing. I have try to debug it with srw.message.
But the trigger is not firing only.

Pls any 1 tell me wht can be reason for tht?
regards,
 
Have You checked permissions on the object you are executing in after rpt trigger. Cheesy Bean
 
check execute permisions on script.

sql> grant ececute to user1 on trigger1 with grant options
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top