Re: Forms4.5 problem
Date: 1997/04/10
Message-ID: <5ihctv$hu3_at_info.csufresno.edu>#1/1
In article <334cca8f.494184_at_news.demon.co.uk>,
Alan Campbell <alan_at_mullen.demon.co.uk> wrote:
>Can anyone advise me on how to get around a problem that I have encountered in
>Oracle forms 4.5.
>
>I have a block that is based on a base table, which displays the contents of
>each record and allows the user to modify the details.
>
>One of the fields (base table) is a status which is held as a character value
>('00'-'07'), which has an associated meaning.
>eg.
>'00' = Registered.
>'07' = Closed.
>
>I want the users to be able to modify this value without having to know what
>each value means.
>
>What I have done is to overlay the status field with another field that is not
>based on a base table item (this field will contain the translation of the
>status), and created a LOV, that displays the translation of the status, the LOV
>also updates the contents of the base table field as well as the new field when
>the user selects a new status.
>This works ok, but the new field is only ever populated when the user selects
>something from the LOV. What I wanted was for the new field to display the
>status when the form starts, so I created a WHEN-NEW-FORM-INSTANCE trigger and
>placed some code in it to populate the new field, based on the status value from
>the underlying table.
>The problem is that the user is always prompted to save any changes to the form
>when they exit (COMMIT_FORM), when they have not made any changes. I am
>assuming this is because I have populated the new field on startup which has
>caused the form status to be set to changed.
You should really be doing your special processing in a post-query trigger on the block. If what you are doing in this trigger still causes the problem with the record status and form status, then at the end of the post-query trigger, you should do this:
Set_Record_Property(Get_Block_Property('BLK_NAME',Current_Record),
'BLK_NAME',Status,Query_Status);
Regards,
Steve Cosner
Try out QA, a dynamic data utility form. Quick display and update access to any table. http://members.aol.com/stevec5088 Received on Thu Apr 10 1997 - 00:00:00 CEST