LOV again change value on same row in oracle form [message #673877] |
Fri, 14 December 2018 00:04 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/852ecf07c0a5af946d1a2771e64ceebb?s=64&d=mm&r=g) |
agm
Messages: 2 Registered: December 2018
|
Junior Member |
|
|
i m using oracle form 6i...I restrict the values of my LOV, that the end user cannot select twice the same...for this i write a code on when validate trigger.now i selected value from LOV for first row but when i selected value from LOV for 2nd row it change the value of first row...cursor not move to second row automatically....
|
|
|
|
|
Re: LOV again change value on same row in oracle form [message #674342 is a reply to message #674339] |
Tue, 22 January 2019 05:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Hard to say but I suspect you've got validate_from_list on (which you should do) and the fact that you are removing items from the group is messing it up.
I never do it that way.
I write an LOV query that excludes values inserted into the table the block is based on.
I then post each record to the DB as it is entered.
|
|
|