Re: LOV with a Dynamic FROM?

Try Create_Group_From_Query. Here is an example:

declare
  rg_id recordgroup := FIND_GROUP('RG_NAME');   table_name varchar2(40) := 'DEPT';
begin
  if not ID_NULL(rg_id) then
    delete_group(rg_id);
  end if;
  rg_id := create_group_from_query('RG_NAME','Select * from '||table_name); end;

This should have cracked the problem for you. If you need more info, let me know.

Joe Strano
Dulcian, Inc.

> I was hoping that one of the Forms experts out there knows of a way to
> create an LOV with a dynamic From clause. I have a requirement to provide a
> list of valid values from a table at a database link specified by the user.
> For example, the user enters a Link Name on the form and then the LOV for
> another field is adjusted to use a known table name at the specified
> database link. I have tried using variables in the from clause and gotten
> syntax or invalid table name errors. I thought that the
> Populate_Group_With_Query command might be of use, but I've been
> unsuccessful thus far.
>
> Does anyone have an idea as to how I might solve this problem? I can't do
> something simple like user synonyms because all of our users are logging
> into one account. (We're using Oracle Applications.) Secondly, the number
> and names of the links are dynamic, so I can't use some type of case
> statement to create the LOVs.
>
> Platform: NCR UNIX, Oracle 7.3.4, Oracle Apps version 10.7,
> SQL*Forms 2.3 or Developer/2000 Forms 4.5
>
> Any suggestions as to how I can meet this requirement would be greatly
> appreciated. Please feel free to contact me directly at
> Suzanne.M.Rose_at_daytonoh.ncr.com.
>
> Thanks in advance,
> Suzanne M Rose
> NCR Corporation
Received on Fri Mar 27 1998 - 00:00:00 CET