This content has been marked as final. Show 7 replies
I have had this same thing happen, but what it was in my case is calling a stored procedure (package/procedure) where that procedure is updating a record. Since the data is being updated on the database and doesn't match forms - in honks with that error. I did what it said, and just re-queried the record after the return from the database.
So... I would look for a call to a stored procedure and see if that is what is happening.
would it be anything to do with that the following items from my datablock are inserted by the database: user whom created the job, date job created, user whom last updated job, date job updated, and each job has a job id which has a unique id generated bya sequence on the database.
All these values are input via the database and not forms triggers, do you think this could be the cause of the problem? if so any suggestions on what to do about it?
Edited by: user13390506 on 16-Aug-2010 07:48
I'm not sure I understand. Are you saying that you have database triggers that are populating those values? If so, then yes that would cause your problem. You would need to remove that logic from the database triggers and stick it in your pre-insert and pre-update triggers. We had a developer do the same thing and had to move the logic.
You are correct. Your database triggers are updating values outside the form.
On the block, set the property value of "DML Returning Value" to "Yes".
See the foms help on this property for full details.
If you have triggers that update insert or update columns like primary key, audit info etc. you can set DML Returning Value property of the block to Yes.1 person found this helpful
"A database update or insert action may initiate server-side triggers that cause alterations or additional changes in the data. In Release 6, when using an Oracle8 database server, Forms uses the DML Returning clause to immediately bring back any such changes. When this property is set to Yes, Forms will automatically update the client-side version of the data, and the user will not need to re-query the database to obtain the changed values."
Oh, same answer as John :-)
Edited by: InoL on Aug 16, 2010 11:10 AM
I never knew that - the things you learn! I wish I would have none that a few months ago that would have made my life easier.
thanks so much guys! appreciate the help!