Re: Updating LOV values programmatically

There is a SET_LOV_PROPERTY of GROUP_NAME which allows you to specify a different group for the LOV. This suggests the possibilty of having a record_group for each possible query and swap groups in the LOV as required. An alternative to having pre-defined record_groups could be to create the

record_group dynamically and then assign it to the LOV. Creating the
record_group dynamically would also work if you destroyed and re-created the
record_group using the same name but a different query. In this case it would

The only hassle I can foresee with these methods is that you would have to keep the number of items in the select list constant otherwise the LOV would complain.

I haven't tested any of these ideas. Just thoughts.

HTH
Geoff

Fred Kuhne wrote:

> For extra clarification, I want to be able to have two very distinct
> queries, not just changing values in the query based on bind variables.
>
> so,
>
> select a from table where x = y
>
> and
>
> select b,c from table where x <> z
>
> not
>
> select a from table where x = :bindvariable
>
> Thanks again.
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Mon Oct 25 1999 - 04:12:48 CEST