IT Community - Software Programming, Web Development and Technical Support

Difference between database triggers and form triggers

This is a discussion on Difference between database triggers and form triggers within the Database Support forums, part of the Web Development category; Difference between database triggers and form triggers a) Data base trigger(DBT) fires when a DML operation is performed on ...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 09-20-2007, 07:41 AM
vijayanand vijayanand is offline
D-Web Analyst
 
Join Date: Feb 2007
Posts: 293
vijayanand is on a distinguished road
Default Difference between database triggers and form triggers

Difference between database triggers and form triggers

a) Data base trigger(DBT) fires when a DML operation is performed on a data base table.Form trigger(FT) Fires when user presses a key or navigates between fields on the screen
b) Can be row level or statement level No distinction between row level and statement level.
c) Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms.
d) Can be fired from any session executing the triggering DML statements. Can be fired only from the form that define the trigger.
e) Can cause other database triggers to fire.Can cause other database triggers to fire,but not other form triggers.
__________________

J.Vijayanand
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference between database triggers and form triggers? ragavraj Database Support 2 11-23-2007 04:54 AM
Difference between Regular database connection and Persistent Database Connections? Falcon PHP Programming 1 11-03-2007 05:13 AM
Error Handling in Triggers Murali Database Support 1 09-20-2007 07:09 AM
If we have multiple AFTER Triggers on table how can we define the sequence of the tri sundarraja Database Support 1 07-24-2007 05:28 AM
diffrence between and constraints and triggers sivakumar Database Support 1 07-12-2007 04:00 AM


All times are GMT -7. The time now is 06:22 AM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.

SEO by vBSEO 3.0.0