| Record Group Problem [message #120261] |
Wed, 18 May 2005 11:01  |
Ammar
Messages: 8
Registered: October 2004
|
Junior Member |
|
|
Dear friends,
Could you help me with this problem, please?
I'm building my system so that the tables in the database are encapsulated with an API, so that no user is allowed to make any direct access to any table, and that any DML operation is done through this API.
The problem is that I couldn't create a record group (on Forms Builder) built on a stored procedure.
Could anyone tell me how to build a record group on a stored procedure?
Note: I'm using Oracle Database 9i, and Oracle Developer/2000 Release 6i
|
|
|
|
| Re: Record Group Problem [message #120298 is a reply to message #120261] |
Wed, 18 May 2005 19:09  |
danosw
Messages: 20
Registered: May 2005
Location: California
|
Junior Member |
|
|
Populate record group by hand...
Are you using this in an LOV? if so set LOV Autofresh = 'NO'
1) create Record_group (MY_GRP) with a dummy query.
IE. select 'NONE ' id from dual
2) Force populate the record group in the WHEN-NEW-FORM-INSTANCE.
i.e if POPULATE_GROUP ('MY_RGP') = '' then null; end if;
3) populate your record group:
BEGIN
--- your loop of p_value's to load
if p_value is not null and
p_value != get_group_char_cell('MY_RGP',1)
then
Add_Group_Row('MY_RGP', 1 );
Set_Group_Char_Cell('MY_RGP', 1,p_value);
end if;
end if;
exception when others then
null;
--- your end loop
END;
----
Good luck,
Dano
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
