Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multi visual attributes on a multi-record block

588035Dec 10 2007 — edited Dec 12 2007
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 9 2008
Added on Dec 10 2007
4 comments
614 views