Home » Developer & Programmer » Forms » variable := NAME_IN('list_name');
variable := NAME_IN('list_name'); [message #79763] Tue, 09 July 2002 14:02 Go to next message
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 ~

Report message to a moderator

Re: variable := NAME_IN('list_name'); [message #79766 is a reply to message #79763] Tue, 09 July 2002 21:38 Go to previous message
Subhash
Messages: 105
Registered: October 2001
Senior Member
As Name_in returns a char value ,that may be causing problem. Try V_PRDT_CODE NUMBER := To_Number(NAME_IN('PRDT_SEARCH_LST'));

Report message to a moderator

Previous Topic: Executing DDL statements in Forms
Next Topic: Executing DDL commands in Forms
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 03:56:21 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.