| variable := NAME_IN('list_name'); [message #79763] |
Tue, 09 July 2002 14:02  |
Tyler
Messages: 123
Registered: January 2002
|
Senior Member |
|
|
My problem is that I'm populating a second list when a value is chosen from the first list (when-list-changed).
My code is...
DECLARE
PUBL_GRP RECORDGROUP;
STATUS NUMBER;
V_PRDT_CODE NUMBER := NAME_IN('PRDT_SEARCH_LST');
BEGIN
clear_list('publication_lst');
PUBL_GRP := CREATE_GROUP_FROM_QUERY('PUBL_GRP',
'select publ_name,TO_CHAR(PUBL_CODE) from
publication,publication_class,product_class
where publ_code = pubc_publ_code
and pubc_clas_code = prcl_clas_code
and prcl_prdt_code = V_PRDT_CODE );
IF NOT ID_NULL(PUBL_GRP) THEN
STATUS:=POPULATE_GROUP(PUBL_GRP);
POPULATE_LIST('PUBLICATION_LST',PUBL_GRP);
END IF;
DELETE_GROUP('PUBL_GRP');
END;
--I'm getting the cannot create group error. But if I hard code the value instead of the v_prdt_code variable, the population works fine....
suggestions??
~ T ~
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
