Trigger Problem, Forms 9i
Date: Fri, 19 Mar 2004 22:46:41 -0000
Message-ID: <bKK6c.542$_r2.9_at_newsfep3-gui.server.ntli.net>
[Quoted] Hi all,
We are running Oracle forms at my University and we have a lot of configuration problems which vary from machine to machine. I cannot get the trigger below tro run (the form loads, the trigger does nothing and no error is displayed). I would appreciate it if someone could tell me if the problem lies with my trigger code or elsewhere:
The aim is to populate a listbox at runtime with the result set of a query:
DECLARE record_group_name VARCHAR2(20) := 'Project_Numbers';
record_group_id RecordGroup;
error_code NUMBER;
BEGIN
- Check that the record group hasn't already been created
record_group_id := Find_Group(record_group_name);
- If the record group has not already been created
IF Id_Null(record_group_id) THEN
- Create the record group
record_group_id :=Create_Group_From_Query(record_group_name,
'SELECT DISTINCT projectNo FROMProject');
END IF;
- Populate the record group with records from the database
error_code := Populate_Group(record_group_id);
- If the query succeeded
IF error_code <> 0 THEN
- Clear the list of its current items, if any
CLEAR_LIST('PROJECTNO'); -- Close any open queries before populating the list ABORT_QUERY(); -- Populate the list with the record group POPULATE_LIST('PROJECTNO', record_group_id); END IF;
END; Thanks in advance,
Johnasc Received on Fri Mar 19 2004 - 23:46:41 CET