Highlisght a particular record [message #522794] |
Wed, 14 September 2011 00:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
isha1812
Messages: 16 Registered: January 2008
|
Junior Member |
|
|
In a form which displays 10 record at one time
I want to highlight the highest salary.
How do I determine and highlight the salary?
which trigger should I use
|
|
|
|
|
Re: Highlisght a particular record [message #522831 is a reply to message #522824] |
Wed, 14 September 2011 01:53 ![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 |
|
|
One option is to loop through all records on the screen, compare all salaries and remember record number (:system.cursor_record) that contains the lowest (or highest, I can't tell as your statements differ) salary; then GO_RECORD that contains it and highlight current record.
Or, maybe you could use :system.last_query to determine the last query executed (if you fetched data from the database), extract its WHERE clause and use it to find the minimum salary (as SELECT MIN(SALARY) FROM YOUR_TABLE WHERE <where_condition_here>). FORMS_DDL might be needed here.
Or, use GET_BLOCK_PROPERTY (DEFAULT_WHERE) or (LAST_QUERY) to find the WHERE clause.
I hope something of the above makes sense.
|
|
|