OraFAQ Forum: Forms » text fields assignment

Home » Developer & Programmer » Forms » text fields assignment

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

text fields assignment [message #307056]

Mon, 17 March 2008 14:00

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

Report message to a moderator

Re: text fields assignment [message #307057 is a reply to message #307056]

Mon, 17 March 2008 14:01

sispk6
Messages: 164
Registered: November 2006
Location: pakistan

Senior Member

it gives the error of bad bind variable. i forgot to mention

Report message to a moderator

Re: text fields assignment [message #307080 is a reply to message #307056]

Mon, 17 March 2008 15:42

sispk6
Messages: 164
Registered: November 2006
Location: pakistan

Senior Member

please do reply,
i need help , in this regard

Report message to a moderator

Re: text fields assignment [message #307150 is a reply to message #307056]

Tue, 18 March 2008 00:27

azamkhan
Messages: 557
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

Report message to a moderator

Re: text fields assignment [message #307365 is a reply to message #307150]

Tue, 18 March 2008 10:49

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

Report message to a moderator

Previous Topic:	HELP PLZZZ
Next Topic:	how to change backgroung colour of menu item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 21:49:56 CST 2025