Re: Dynamic List Items in Forms 4.5

Dan Stern (dstern_at_gte.net) wrote:
: I have a "country" field and the options are Canada or United States.
: The next field is "State/Province", if Canada was selected, I would want
: to pull out the "list item" and the "list item value" from another table
: based on a sql search triggered by leaving the country field.
:
: Is that clear?

We had exactly the same problem:

User chooses a Building, and then he can select the parts of this building in another list item. The two list items are based on different tables, which makes sense in the db design.

The problem we encountered were the following:

• When querying, always make sure the value coming from the DB is present in the list, because if not the whole record is 'silently rejected' (see oracle documentation, Forms reference manual). So when the query is open and you do next_record, we had to fill up the list with all possible values, then change the list.
• the whole thing doesn't work if the query is open (see also forms reference manual). We didn't want to query all 3500 records, so what we did was combining the two tables to one list item. For the other cases where this list would get too long, we used LOVs.

If you find a way to circumvent my problems, please mail me !

My bottomline: Never use oracle items the way they were not meant to be.

Walter

walter.zimmer_at_rz.uni-ulm.de
Forms 4.5.7.1.2 developer (solaris, NT) Received on Tue Jun 03 1997 - 00:00:00 CDT