| each second record with different background_color [message #85580] |
Fri, 09 July 2004 15:21  |
hudo
Messages: 165
Registered: May 2004
|
Senior Member |
|
|
Hello,
to improve legibility, I would like to display always the second row with another (lets say green) background_color.
Therefore I created a BLOCK - Post-Query Trigger containing the following lines:
--IF (:EMP.COMM IS NULL) THEN
IF (MOD (TO_NUMBER(:SYSTEM.CURSOR_RECORD), 2) = 0 ) THEN
SET_ITEM_INSTANCE_PROPERTY('EMP.ENAME', CURRENT_RECORD, VISUAL_ATTRIBUTE ,'GREEN_BACKGROUND');
END IF;
NULL;
My first problem: I do not know how to the determine the whole record, therefore I just used EMP.ENAME
Second problem: The green background starts at record number 7 (if the first record is number 1, (is this so, or does it start with zero ??)), and then number 9, 11, 13 (from scott.emp) has a green background-color.
Please give me some advice
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
