| How to Check a listbox change in oracle forms [message #640401] |
Tue, 28 July 2015 01:45  |
 |
PREETISINGLA
Messages: 3
Registered: June 2015
|
Junior Member |
|
|
|
Hello Every One,i have created a form where there are four list boxes, now my requirement is how can i check whether the values in any of the listbox is changed or not . whether we have to make use of any trigger or pl/sql block..please guide me regarding it.
|
|
|
|
|
|
| Re: How to Check a listbox change in oracle forms [message #640495 is a reply to message #640401] |
Wed, 29 July 2015 09:06  |
rajesh4851
Messages: 89
Registered: January 2007
|
Member |
|
|
what Craig said is correct.
Here is another way:
Create 4 global variables in WHEN-NEW-FORM-INSTANCE or POST-QUERY (If its single record block) and store the 4 list item values in that global variables.
Now compare that 4 global variables to current items in WHEN-VALIDATE-RECORD trigger .
below is sample code :
IF :GLOBAL.ITEM1 = :BLOCK1.ITEM1
OR
:GLOBAL.ITEM2 = :BLOCK1.ITEM2
OR
:GLOBAL.ITEM3 = :BLOCK1.ITEM3
OR
:GLOBAL.ITEM4 = :BLOCK1.ITEM4
THEN
MESSAGE('Value has been changed');
MESSAGE('Value has been changed');
END IF; |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
