while inserting one record, other 5 records are also getting updated [message #606261] |
Tue, 21 January 2014 14:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/95c9b98450e177e0af71a941ba0ac6da?s=64&d=mm&r=g) |
nkumar0130
Messages: 55 Registered: August 2013 Location: Bangalore
|
Member |
|
|
Hi,
I am having a tabular block which is based on a table.the size of block is only 5 rows.
So while inserting a new record then other 5 records are also getting updated(only the who columns are getting updated).
The same thing is happening while updating a record. If I am updating a record other 5 are also getting updated.
Any suggestions is highly appreciated.
|
|
|
|
|
Re: while inserting one record, other 5 records are also getting updated [message #606306 is a reply to message #606305] |
Wed, 22 January 2014 03:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
It's the same suggestion - find the code that's modifying the records and fix it.
Try running the form in debug mode to see what triggers are firing.
You could also use messages to display :system.record_status and use that to work out when the records status goes from QUERIED to CHANGED.
And you should never need an on-update trigger.
|
|
|
Re: while inserting one record, other 5 records are also getting updated [message #606307 is a reply to message #606305] |
Wed, 22 January 2014 03:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Which Forms version do you use? If it is 10g (or above), run the form in debug mode. If lower (6i), you'll have a lot of work to find the culprit (by including MESSAGE calls into every trigger you have ... what a tedious job, with a doubtful outcome!).
If it is not ON-UPDATE, then it is something else.
Which item(s) are changed? All of them or some of them? Try to search PL/SQL code in your form (in 10g, it is under Edit menu, "Find and replace PL/SQL ..." and search for item's name that gets changed.
|
|
|