Home » Developer & Programmer » Forms » bind variable
bind variable [message #306372] Thu, 13 March 2008 23:47 Go to next message
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 Go to previous message
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

Previous Topic: passing parameter to report from form in 10g
Next Topic: Dynamically populate 2nd drop down list based on the 1st list value
Goto Forum:
  


Current Time: Fri Dec 02 18:55:13 CST 2016

Total time taken to generate the page: 0.40407 seconds