Dear all,

How could I pass parameter to a trigger?

Any kind of assistence is greatly accepted.

It's not possible in a stored procedure or function sense. Triggers can pull data from the virtual inserted and deleted tables plus any other base table. Therefore, you could read data from a base table that contained lookup data for configuration, etc. An example would be if you wanted the alter or insert data based on the geographic location of the user inserting.

Hope this helps.

Adam Gossage
Lake Wylie, SC, USA

Dear Agossie,

many thanks to u for this reply. Actually i am facing a problem. The details of the problem is:
If a perticular record is closed, then based on the state like open, close or in process, certain calculation will be done. I want to do this calculation by trigger . Here the problem is I cant specify the perticular record, so i want to pass the paramater to the trigger.

Any help is greatly appreciated.

Thanking you,

I am not sure I am following you on the 'not specifying the particular record'. Would you submit an example, even if it is in pseudo-code?

I am sure there is a way to accomplish the task. I just need more details.

Adam Gossage
Lake Wylie, SC, USA

Why would you want to do that using triggers? What is that you are looking to do in this case? Can you elaborate as agossage said?

I hope you should be looking for a Stored procedure to do this. Triggers cannot be passed with parameters, and triggers are invoked by either Insert/Update/Delete operations on the table.

How about posting more info on this?

Cheers.

_________________________
- Vijay G
Strive for Perfection

Dear happygv and agossage
Probably I have solved the problem. I will send it all of you. i will give the details code here. Just give me some time.