|creating record group with query problem [message #262669]
||Tue, 28 August 2007 01:05
Registered: August 2007
i want to make a run time record group and associate it to the the LOV which then populated to a text item(session). |
But i add a where class in SQL statement which select data according to the value of another text item(class).
i write the following code on post_change trigger of text item(class).
/* create the group rc_se and assign its id to the
** variable group_id */
group_id := Create_Group_From_Query ('rc_se',
FROM sesion s, class_code c
WHERE c.class = data.class AND c.session_id = s.session_id');
/* now execute the new group's query, using the variable
** group_id to identify the group */
query_ok := Populate_Group(group_id);
/* if the query failed, abort this trigger by raising a
** predefined exception */
IF query_ok <> 0 THEN
At copmliation process there is no error. but when a run form and go the text item(session) a got errors
FRM-41072 cannot create group rc_sc
FRM-41076 error populating group.
now will any body solve this problem,
i need it urgently