Re: Help with repopulating a poplist with Forms 6.0

Hi Geoff,

U Da Man!!!!

Thanks very much. That worked. I had to rework a few things with my triggers, but basically I now can repopulate my poplist!

Take care,
Scott G.

On Tue, 12 Oct 1999 09:54:23 +0800, Geoff White <whiteg_at_ccis.adisys.com.au> wrote:

>"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 Tue Oct 12 1999 - 11:53:56 CDT