topic Re: Difference between routine and a trigger in Application Development and Automation Discussions

Difference between routine and a trigger

Former Member — Wed, 25 Apr 2007 06:44:23 GMT

Hi Forum,

I have a doubt about routines, is routine the same as a trigger in terms of database language. If not then what does routine does coz both are condition setters?

Please help.

Tanya

Re: Difference between routine and a trigger

Former Member — Wed, 25 Apr 2007 06:49:50 GMT

Hi,

Routines are related to Programs- comes under modularization. That is not at all related to Database.

Regards,

Sudheer

Re: Difference between routine and a trigger

Former Member — Wed, 25 Apr 2007 06:50:49 GMT

Hi,

Routines: sometimes called subroutines are set of command which is grouped and can be called whenever required.. Routines are called with perform <SUBROUT_NAME> and created with form (subroutine_name) and endform.

its major fucntion is to perform specific operation e.g. caluclate interest. Paraemters are passed to Subroutines.

DB Trigers: This are differnt in term of funcationality. DB Trigeers are fired whenver any DB event is occured. like change, add record, dele record. but u may call routines in trigers.

Hope this will help you.

Jogdand M B

Re: Difference between routine and a trigger

Former Member — Wed, 25 Apr 2007 06:51:42 GMT

Hi,

its major fucntion is to perform specific operation e.g. caluclate interest. Paraemters are passed to Subroutines.

DB Trigers: This are differnt in term of funcationality. DB Trigeers are fired whenver any DB event is occured. like change, add record, dele record. but u may call routines in trigers.

Hope this will help you.

Jogdand M B

Re: Difference between routine and a trigger

Former Member — Wed, 25 Apr 2007 07:08:50 GMT

routines : routines should be called and this is related to reports..

syntax perform <subroutine name>

form

endform.

where as Trigger are related to database .it need not to be called explicitly

when we do some actions such as insert ,delete, modify and included trigger in that.then as soon as any one of the action is performed it will give the popup.