| while inserting one record, other 5 records are also getting updated [message #606261] |
Tue, 21 January 2014 14:52  |
 |
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  |
cookiemonster
Messages: 13963
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 |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
