Re: Need advice on Oracle Forms

[Quoted] Er... didn't you recently start a thread regarding the same issue? You may [Quoted] want to refer back to your original thread and save some time because you're [Quoted] going to get the same answers all over again. Just to recap:

option #1: use display items instead of text items for fields that are populated post-query and that do not need to be interactively edited. Whenever you alter a text item in a database block it also changes the block [Quoted] status to 'changed', even if the item is not bound to a table field.

option #2: base your block on a view

option #3: create a control block to seperate the bound fields from the display fields

"Dave Williams" <davetati_at_dsli.com> wrote in message news:UVmdndodLIhVgqWiXTWJkg_at_dsli.com...
> All,
>
> I am looking for the best way to code/design a form around several tables
> that I have. I will go into detail as to what I am trying to do.
>
> I have 3 tables: Users, Depts and Roles.
>
> A user belongs to a dept and has a role. Other information in the user
> table is the country he/she resides along with Oracle apps login name and
> e-mail.
>
> I want this form to be a muti-purpose form that allows an admin type
person
> to add users and to add new roles and depts. Countries come from
> FND_TERRITORIES_TL.
>
> I envision the form having 3 tabs. One for users, 1 for depts and 1 for
> roles.
>
> On the tab for user maintenance I obviously want to validate entry for
roles
> and depts (and countries) to be valid against the appropriate tables. The
> user table has dept_id, role_id and terriotry_short_name as references to
> the other tables.
>
> So I need to create additional fields in the user tab to allow for dept
> name, role name and country name. These extra fields will have LOV's on
> them that validate the data entry against the other tables.
>
> This works well when creating new users. When querying back existing
users
> I need to execute a post-query trigger to go get the dept name, role name
> and country name based upon the id that comes back from the user table.
>
> Again, this is all good except that if I try and close the form after the
> query then I get asked if I want to save the data. There is no real
update
> to the data but the form thinks there is because the post-query trigger is
> populating some text items for dept name, role name and country name.
>
> So, what is the best way to do this ? I could set the record status to
> QUERY at the end of the post-query trigger. But, is there a nicer way of
> doing this ?
>
> Please note, the problem is in the USER tab part of the form since it
> references data from other tables. The DEPT and ROLE tabs are just fine
> because it is all based upon a single table.
>
> Any help/advice would be much appreciated.
>
> TIA.
>
> Dave.
>
>
Received on Tue Aug 12 2003 - 01:35:00 CEST