Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » COMMIT_FORM (10g DS10)
COMMIT_FORM [message #434652] Thu, 10 December 2009 02:19 Go to next message
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
Re: COMMIT_FORM [message #434675 is a reply to message #434652] Thu, 10 December 2009 04:05 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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).
Re: COMMIT_FORM [message #434722 is a reply to message #434675] Thu, 10 December 2009 06:29 Go to previous message
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
Previous Topic: Report_path On applicaiton server report services
Next Topic: Problems installing Oracle 10g in Windows XP SP2.
Goto Forum:
  


Current Time: Sat Dec 10 17:02:03 CST 2016

Total time taken to generate the page: 0.10062 seconds