Re: Oracle Forms 4.5 question

assoy_at_my-deja.com wrote:

> Hi,
> I am using Forms 4.5 and Oracle 7.
> What I am trying to do here is:
>
> Using combo box to populate the database.
> The table that I am referencing :
> <snip (so my mail will send)>

> So that when I add more data in the cred_code table,
> ie : INSERT INTO CRED_CODE ( CRED_CODE, CRED_DESC)
> VALUES ( 6,'Very Excellent');
> I do not need to change the List Element. Instead it will automatically
> populated
> using the select statement.
>

You can do this using a record group to populate your list. The steps are:1. create a record group which selects the description and value from your code table. This record group can either be defined at design time in the Navigator or can be generated at runtime using the create_group_from_query built-in. Note - you must always have 2 columns. 2. in a trigger :
  . populate the group using the populate_group built-in.   . populate the list using the populate_list built-in. The trigger you use depends on when you wish to refresh the list - use WHEN-NEW-FORM-INSTANCE if you only wish to load the list once when the form is opened. use WHEN-NEW-RECORD-INSTANCE if you wish to load the list each time a new record is created.

HTH
Geoff

> Thank you for your help
>
> Assoy
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Jul 13 1999 - 22:55:57 CDT