error 49 bad bind variable [message #535483] |
Wed, 14 December 2011 04:59 |
|
omernas
Messages: 3 Registered: June 2011 Location: sudan
|
Junior Member |
|
|
hi i am getting this error when compiling (error 49 bad bind variable) is there anything wrong in this
(
declare
total_rec number(2);
begin
:new_id:=null; :new_sal:=null;
:new_name:=null; :new_tel:=null;
:new_job:=null; :new_date:=null;
:new_address:=null;
total_rec:=to_number(GET_LIST_ELEMENT_COUNT('EMP_NAME_LIST'));
if GET_LIST_ELEMENT_LABEL('EMP_NAME_LIST',total_rec)is null then
:new_id:=1;
else
select nvl(max(ply_id),0)+1 into:new_id from employee;
end if;
SHOW_window('addd',40,40);
SET_ITEM_PROPERTY('dis1',VISIBLE,PROPERTY_false);
GO_ITEM('new_name');
end;
)
the code in the add-new command
when_button_pressed trigger
am adding employee to the employee table by this form
thanks in advance...
|
|
|
|