OraFAQ Forum: Forms » Need help urgently!!! insert multiple lines from tabular

Home » Developer & Programmer » Forms » Need help urgently!!! insert multiple lines from tabular

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

Need help urgently!!! insert multiple lines from tabular [message #79301]

Wed, 22 May 2002 17:43

Kelly
Messages: 9
Registered: January 2002

Junior Member

I want to insert multiple line from tabular form into my database without using commit_form command. Does anyone know how to do that. I use insert command but it seems to insert only information on the last line not all lines.

Report message to a moderator

Re: Need help urgently!!! insert multiple lines from tabular [message #79305 is a reply to message #79301]

Wed, 22 May 2002 21:48

Remash
Messages: 52
Registered: November 2000

Member

Assume you have a block 'TEST' and has multipile lines of information. To save the info. into the table without COMMIT_FORM, do the following.

GO_BLOCK('TEST');
FIRST_RECORD;

LOOP
INSERT INTO .........

IF :SYSTEM.LAST_RECORD = 'TRUE' THEN
EXIT;
END IF;

NEXT_RECORD;
END LOOP;

Report message to a moderator

Previous Topic:	urgent...plz help.
Next Topic:	TEXT_IO

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 05:56:59 CDT 2024