OraFAQ Forum: Server Administration » Entering a character return in a memo field

Home » RDBMS Server » Server Administration » Entering a character return in a memo field

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

Entering a character return in a memo field [message #374595]

Wed, 20 June 2001 10:16

Kristy
Messages: 2
Registered: June 2001

Junior Member

I have 4 input boxes in a form. These 4 inputs go in one column in SQL. When I write my INSERT statement how do I enter character returns?

Report message to a moderator

Re: Entering a character return in a memo field [message #374596 is a reply to message #374595]

Wed, 20 June 2001 12:24

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi,

user chr(10) for carriage return

insert into t1 (var1 || chr(10) || var2 || chr(10) || var3 || chr(10) || var4);

Bala.

Report message to a moderator

Re: Entering a character return in a memo field [message #374656 is a reply to message #374595]

Fri, 22 June 2001 20:02

palanikarupaiyan@hotmail.
Messages: 18
Registered: June 2001

Junior Member

This is based on your FrontEnd... Suppose ur front end is VB, write your sql in VB code like

"INSERT INTO TABLE1 (Field1) values('" +
Text1.Text+Text2.Text+Text3.text+Text4.text+"')"

EXECUE the above statement from the EXECUTE method of Any ADO or DAO objects.

That's it.
Palani.

Report message to a moderator

Previous Topic:	Re: retriving last 10 rows
Next Topic:	selecting LIKE from LONG datatype?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 04:18:10 CDT 2024