Home » Developer & Programmer » Forms » text fields assignment
text fields assignment [message #307056] Mon, 17 March 2008 14:00 Go to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
hi friends ,
i have text fields in my data block as ..
field name ,
col1 , col2 ,col3 , col4 , col5 , col 5 ,col6, col7.
now whatever source sends me i populate in a loop my block as..
<code>
i := 1 ;
loop
:col||i := value ;
i := i + 1 ;
exit when condition ;
end loop ;
</code>
but i get an error can some body help me how to do that.
thanx in advance
Re: text fields assignment [message #307057 is a reply to message #307056] Mon, 17 March 2008 14:01 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
it gives the error of bad bind variable. i forgot to mention
Re: text fields assignment [message #307080 is a reply to message #307056] Mon, 17 March 2008 15:42 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
please do reply,
i need help , in this regard
Re: text fields assignment [message #307150 is a reply to message #307056] Tue, 18 March 2008 00:27 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear you cannt do this

:col||i := value;

I understand you want to assign value to variable dynamically. For this use

COPY (source VARCHAR2, destination VARCHAR2);

This builtin procedure will copy you defined source value to your defined variable.

Regards,
Azam Khan
Re: text fields assignment [message #307365 is a reply to message #307150] Tue, 18 March 2008 10:49 Go to previous message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
OHH YA ?
I KNEW THERE WAS ANOTHER WAY AROUND BUT I FORGOT ,
THANX A LOT
Previous Topic: HELP PLZZZ
Next Topic: how to change backgroung colour of menu item
Goto Forum:
  


Current Time: Sun Dec 04 12:51:30 CST 2016

Total time taken to generate the page: 0.08684 seconds