Difference between routine and a trigger

[Former Member]

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

[Former Member]

Hi,

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

Regards,

Sudheer

[Former Member]

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

[Former Member]

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

[Former Member]

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

syntax perform <subroutine name>

form

<statement1>

<statement2>

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.