| bind variable [message #306372] |
Thu, 13 March 2008 23:47  |
rane_sarita333
Messages: 3
Registered: March 2008
Location: India
|
Junior Member |
|
|
hiii
i have some problem in bind variable and trigger variable.
The case is like this. I have ten check boxes in form and there names r stored in oracel database.Now i want to dyanmically check this check box(i.e. to make check value=1).
for this i written a cursor which return selected number of check boxes and when i press event occur this check boxes should be checked in form.
code is like below:
declare
cursor c is select item from rights where idcode = :id
sa rights.item%type;
begin
for j in c loop
sa :=j.item;
:sa :=1; //error bad bind variable
end loop
end;
now 'SA' is variable which contain name of checkbox and after that i want to assign value to that check box is '1'.so that it will be checked.
but it gives error .
please help me to solve this problem or tell me the way to dynamically assign value to check box.
please
|
|
|
|
| Re: bind variable [message #306439 is a reply to message #306372] |
Fri, 14 March 2008 03:57  |
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
|
Senior Member |
 
|
|
in this case use Copy buildin to assign value.
declare
cursor c is
select item from rights where idcode = :id;
begin
for j in c loop
copy(1,j.item); // use of Copy.
END Loop;
end;
Gopal
[Updated on: Fri, 14 March 2008 03:58] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
