Difference between COMMIT_FORM and Forms_ddl('commit')

[parbhani]

Hi all ,

I am using forms 6i, deployed on 9iAS.
What is the difference between COMMIT_FORM and
FORMS_DDL('COMMIT') ??

Please guide

 

[sem]

COMMIT_FORM applies all changes, while FORMS_DDL('COMMIT') just commits current transaction. When you make some changes through Forms, records in database are not updated immediately, just locked (default behaviour). When you issue POST_FORM, that changes are really applied (you may see a message: x records applied). COMMIT_FORM calls both POST_FORM and COMMIT, thus you obtain another message: x records applied and saved. When you call commit within pl/sql, commit_form is called indeed. That's why in many cases you get an annoying message: no changes to apply.

Regards, Dima

http://seminihin.narod.ru

 

[parbhani]

What a nice answer .........
Thanks a lot