Multi visual attributes on a multi-record block
588035Dec 10 2007 — edited Dec 12 2007Hi all
I have a multi record block and trying to maintain different sets of visual attributes depending on record type (new or existing) and whether current record or not. I'm using 10g forms
1) Existing records from the DB to be displayed using visual attribute 'VA_EXISTING' (black on grey, bold font)
2) New records that the user will add (below existing records) to be displayed in plain black on white, normal font (default)
3) The currently selected record/row, new OR existing, to be displayed using visual attribute 'VA_CURRENT' (black on yellow). Now this is the tricky bit. If the current record is existing (QUERY) it should appear black on yellow, bold font. If the current record is new (INSERT) it should appear black on yellow, normal font.
So far I've tried setting the current record visual attribute property at block level for VA_CURRENT, black on yellow (normal font). This works fine on its own. However, when I change the appearance of existing records to VA_EXISTING in a post query trigger, it appears to wipe out or override the VA_CURRENT settings as the current row does not appear as expected when I move focus to different rows.
Any suggestions will be greatly appreciated.