Re: Help with repopulating a poplist with Forms 6.0

From: Geoff White <whiteg_at_ccis.adisys.com.au>
Date: Tue, 12 Oct 1999 09:54:23 +0800
Message-ID: <380294CF.CD3CAECD@ccis.adisys.com.au>

"Scott G." wrote:

> <snip>

>
> group_id := Find_Group(group_name);
> IF Id_Null(group_id) THEN
> group_id := Create_Group_From_Query(group_name, 'SELECT
> distinct to_char(last_name||', '||first_name) name,
> to_char(owner_id) owner_id from activity_owner');

I can see 2 problems in your select statement. 1. you are using to_char around (what appear to be) character columns. 2. the sequence of quotes in the statement actually split it into 2 strings separated by a comma.
What I think you might need is:

        group_id := Create_Group_From_Query(group_name, 'SELECT
             distinct last_name||'', ''||first_name name,
             to_char(owner_id) owner_id from activity_owner');

The '' is 2 single quotes together.

HTH
Geoff

<snip> Received on Mon Oct 11 1999 - 20:54:23 CDT