OraFAQ Forum: Weblogic & Application Server » COMMIT

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » COMMIT_FORM (10g DS10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

COMMIT_FORM [message #434652]

Thu, 10 December 2009 02:19

rkgoyal98
Messages: 39
Registered: October 2009

Member

We have a large no. of forms where data is displayed as a result of query. New records can also be entered by the users and existing data can also be updated. We are capturing date/time of insert or update trough a trigger on the table in a column. Our problem is that whenever data is saved through the form all the records within form are treated as updated by the trigger and date/time is changed even though user has not changed anything in some of the records.
We are using COMMIT_FORM(NO_VALIDATE) for saving the data.
My question is is there anyway by which we can issue difrential Commit ( Only updated or inserted recoreds to be commited in the database).

Regards

Report message to a moderator

Re: COMMIT_FORM [message #434675 is a reply to message #434652]

Thu, 10 December 2009 04:05

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps *something* has changed in all of those records, not just the ones you think. For example, maybe there's the WHEN-NEW-RECORD-INSTANCE or POST-RECORD or ... trigger that does certain update in displayed or - possibly - hidden form item. So, although such a record looks the same, it has changed.

Therefore, you might check whether the above happens in your form(s).

Report message to a moderator

Re: COMMIT_FORM [message #434722 is a reply to message #434675]

Thu, 10 December 2009 06:29

rkgoyal98
Messages: 39
Registered: October 2009

Member

Thanks for such a quick resposne. Though i have checked the items on the block but will again review each and evry item and will come back if problem remains
Regards

Report message to a moderator

Previous Topic:	Report_path On applicaiton server report services
Next Topic:	Problems installing Oracle 10g in Windows XP SP2.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 11 16:53:44 CDT 2025