OraFAQ Forum: Forms » Multiline data, showing in one Text Field

Home » Developer & Programmer » Forms » Multiline data, showing in one Text Field (oracle 10g, win xp)

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

Multiline data, showing in one Text Field [message #496581]

Tue, 01 March 2011 02:26

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

Dear All

I have got data in a table like

ID Service
1 A
1 B
1 C

I have written a cursor which is fetching it like A,B,C and assigning it in a display field.
It is working fine.

I want to display it in single text field but in multiple lines.
i have set the property multiline to yes in property insepector.
I want to display it like

A
B
C

but it should remain in single field/text box.

Infact i am unable to break the line in cursor.

any solution is welcome.

regards.

Report message to a moderator

Re: Multiline data, showing in one Text Field [message #496587 is a reply to message #496581]

Tue, 01 March 2011 03:33

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Loop over cursor. Assign each value to a single varchar2 variable. seperate each value with a carriage return - chr(10).
Assign end result to datablock item.

Report message to a moderator

Re: Multiline data, showing in one Text Field [message #496598 is a reply to message #496587]

Tue, 01 March 2011 04:01

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

thanks dear... it worked.

Report message to a moderator

Previous Topic:	Forms 10g
Next Topic:	Alternate for OLE in unix application server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 00:52:28 CST 2025