what are difference between post database commit and
post-form commit?
Answers were Sorted based on User's Feedback
Answer / chaudhry
Post-form commit fires once during the post and
commit transactions process, after the database commit
occures. The post-form-commit trigger fires after
inserts,updates and deletes have been posted to the
database but before the transactions have been
finalished in the issuing the command.The
post-database-commit trigger fires after oracle forms
issues the commit to finalished transactions.
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / sudipta santra
Both the trigger will fire after the commit occur in the
forms, but the difference makes that : Post-Form-Commit
fires in between the post to the database and committed the
transaction whereas, the Post-Database-Commit fires after
the committed transaction in database.
Note: If the two triggers are written or applied, then Post-
Form-Commit will fire first then Post-Database-Commit will
fire.
| Is This Answer Correct ? | 3 Yes | 1 No |
in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in that if any ething is selected then that will display in the report.supp if i am not selected any value then it should display all the values.how it is possible?can any one help me........
From which designation is it preferred to send the output to the printed?
Can you attach an lov to a field at run-time? if yes, give the build-in name.
What is the difference between Anchoring Object and Enclosing Objects ?
What is the use of Data Link in Reports?
Can a root window be made modal?
What are the various sub events a mouse double click event involves?
When is PRE-QUERY trigger executed ?
what is the diffrence between before parameter form triger & formate trigger
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?
What are the vbx controls?
What are the default extentions of the files created by menu module?