Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    43

    Unanswered: Oracle forms question

    Is it possible to have specific rows in a tabular block a different colour to the rest, if certain criteria are met.
    For example you have a block based on an orders table, in this table you have a cancellation date. Instead of showing this cancellation date in the form you want cancelled orders to be highlighted red.

    If it is possible how could you do it?

    Any help appreciated!

  2. #2
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    i am working on the same issue. I've been told u can do that with visual attributes and using the set_item_instance_property build_in but i have not yet been able to do so.
    When I do, you'll hear from me, and if u try it and get it working before i post a reply, please reply to me.

    Greetz
    Edwin van Hattem
    OCP DBA / System analyst

  3. #3
    Join Date
    Oct 2003
    Posts
    2

    Re: Oracle forms question

    Originally posted by chumpski
    Is it possible to have specific rows in a tabular block a different colour to the rest, if certain criteria are met.
    For example you have a block based on an orders table, in this table you have a cancellation date. Instead of showing this cancellation date in the form you want cancelled orders to be highlighted red.

    If it is possible how could you do it?

    Any help appreciated!
    --

    hows about:

    lets say you have a column that is an ORDER_STATUS
    create an POST-CHANGE on that column
    --
    IF :BLK_NAME.ORDER_STATUS='C' THEN
    DISPLAY_ITEM('BLK_NAME.ORDER_STATUS','VIS_ATT_CANC EL');
    END IF;

    or
    IF :BLK_NAME.CANELLATION_DATE IS NOT NULL THEN
    DISPLAY_ITEM('BLK_NAME.ORDER_STATUS','VIS_ATT_CANC EL');
    END IF;

    Look up "display_item" in the help section of forms.

  4. #4
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    I did not try using the DISPLAY_ITEM build_in, but i used visual attributes. I added a visual attibute to my template, and in a trigger i used the SET_ITEM_INSTANCE_PROPERTY, to change the visual attribute and generated the form. I use designer. For those of u who just build them forms in developer, just add a visual attribute to the fmb.

    Good luck.
    Edwin van Hattem
    OCP DBA / System analyst

  5. #5
    Join Date
    Oct 2003
    Posts
    43
    Thank you the Built-in: SET_ITEM_INSTANCE_PROPERTY has worked a treat!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •