| Highlisght a particular record [message #522794] |
Wed, 14 September 2011 00:47  |
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  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
