| prameter help urgent and prameter (merged) [message #163613] |
Fri, 17 March 2006 08:53  |
eswaries
Messages: 41
Registered: January 2006
|
Member |
|
|
PARAMETER:
I am using oracle 8 and Forms [32 Bit] Version 6.0.8.8.0 (Production)
I have one menu table.
sql> desc menu
name null? type
------------------------------- -------- ----
no not null number
item varchar2(30)
price number(8,3)
type not null varchar2(30)
select * from menu;
NO ITEM PRICE TYPE
------ ------------------------------ --------- --------
1001 idli 10 tiffin
1002 DHOSAI 10 TIFFIN
1003 PONGAL 12 TIFFIN
1004 VADAI 5 TIFFIN
1005 CHAPPATHTHI 13 TIFFIN
1006 POORI 12 TIFFIN
1007 NAAN 30 TIFFIN
1008 BUTTER NAAN 40 TIFFIN
forms:
In the forms i put three push buttons and in the 1 push button i write one trigger to create parameter under when_button_pressed
declare
pl_id paramlist;
pl_name varchar2(10) := 'ESHWARI';
begin
pl_id := get_parameter_list(pl_name);
if id_null(pl_id) then
pl_id := create_parameter_list(pl_name);
message('created');
if id_null(pl_id) then
message('error creating parameter list '||pl_name);
raise form_trigger_failure;
end if;
else
message('parameter list '||pl_name||' already exists!');
raise form_trigger_failure;
end if;
end;
it works well.
but when i add the parameter list it does not work
declare
pl_id paramlist;
begin
pl_id := get_parameter_list('ESHWARI');
if not id_null(pl_id) then
add_parameter(pl_id,'ITEM’,text_parameter,'DHOSAI’;
end if;
end;
When I run this code It creates an error
FRM-47013: Cannot add parmeter ITEM to paramlist
ESHWARI: Parameter with this name exist
|
|
|
|
|
|
| prameter help urgent [message #163839 is a reply to message #163613] |
Mon, 20 March 2006 05:36  |
eswaries
Messages: 41
Registered: January 2006
|
Member |
|
|
please check .first i tell my doubt i cannot add parameter.
PARAMETER:
I am using oracle 8 and Forms [32 Bit] Version 6.0.8.8.0 (Production)
I have one menu table.
sql> desc menu
name null? type
------------------------------- -------- ----
no not null number
item varchar2(30)
price number(8,3)
type not null varchar2(30)
select * from menu;
NO ITEM PRICE TYPE
------ ------------------------------ --------- --------
1001 idli 10 tiffin
1002 DHOSAI 10 TIFFIN
1003 PONGAL 12 TIFFIN
1004 VADAI 5 TIFFIN
1005 CHAPPATHTHI 13 TIFFIN
1006 POORI 12 TIFFIN
1007 NAAN 30 TIFFIN
1008 BUTTER NAAN 40 TIFFIN
forms:
In the forms i put three push buttons and in the 1 push button i write one trigger to create parameter under when_button_pressed
declare
pl_id paramlist;
pl_name varchar2(10) := 'ESHWARI';
begin
pl_id := get_parameter_list(pl_name);
if id_null(pl_id) then
pl_id := create_parameter_list(pl_name);
message('created');
if id_null(pl_id) then
message('error creating parameter list '||pl_name);
raise form_trigger_failure;
end if;
else
message('parameter list '||pl_name||' already exists!');
raise form_trigger_failure;
end if;
end;
it works well.
but when i add the parameter list it does not work
declare
pl_id paramlist;
begin
pl_id := get_parameter_list('ESHWARI');
if not id_null(pl_id) then
add_parameter(pl_id,'ITEM’,text_parameter,'DHOSAI’;
end if;
end;
When I run this code It creates an error
FRM-47013: Cannot add parmeter ITEM to paramlist
|
|
|
|
| Re: prameter help urgent [message #163948 is a reply to message #163839] |
Mon, 20 March 2006 22:44 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
STOP POSTING THE SAME QUESTION AGAIN!!!
Open the Forms Builder reference manual in Adobe. Search for Add_parameter - you HAVE TO DELETE the old list before creating the new one. This answer is in the forum. Search for 'create_parameter delete_parameter'.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
