Re: populate record group error

Diane Perkins wrote:

> I am trying to write a proceedure to create a recordgroup based on a
> select statement, when I use sql-plus the select statement works,
> however, in the program I get the error: unable to populate the record
> group. Following is my code:
>
> Declare
> group_id RecordGroup;
> query_ok NUMBER;
> BEGIN
> group_id := Create_Group_From_Query('common_group', 'SELECT
> role.name,
> screen.name FROM role, screen WHERE
> role.name = formCategory', GLOBAL_SCOPE);
>
> query_ok := Populate_Group(group_id);
> IF query_ok <> 0 THEN
> RAISE FORM_TRIGGER_FAILURE;
> END IF;
> END;
>
> Thanks for any help!!
> Diane Perkins
> perkinsdt_at_navair.navy.mil

Check the status of the block. You can only populate when the status is NEW (I think),
anyway, it should not be CHANGED.
If you use Headstart, get a bugfix; Headstart changes some defaults (and thus the block status)
before the call to populate your group is made. BTW that may also help: move it to the pre-form trigger

Hth,

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle