Home » Developer & Programmer » Forms » CAN ANY ONE HELP ? PLZZZZZZ
CAN ANY ONE HELP ? PLZZZZZZ [message #86435] Wed, 29 September 2004 21:33 Go to next message
domingo
Messages: 54
Registered: June 2004
Member
I have a problem on a form that I need to correct .

When multiple rows are entered commit does not work.

The commit will work when 1 row is entered and then committed.

How to make commit  work when multiple rows are inserted

thanks

  Domingo
Re: CAN ANY ONE HELP ? PLZZZZZZ [message #86442 is a reply to message #86435] Thu, 30 September 2004 01:34 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Domingo,
Is your block is Database block or a control block?
Are there any master-detail-detail relationships?

Regards
Himanshu
Re: CAN ANY ONE HELP ? PLZZZZZZ [message #86444 is a reply to message #86442] Thu, 30 September 2004 03:20 Go to previous messageGo to next message
domingo
Messages: 54
Registered: June 2004
Member
There are two blocks both are database blockas
there is also a master detail relationship among the two blocks
thankz
domingo
Re: CAN ANY ONE HELP ? PLZZZZZZ [message #86463 is a reply to message #86435] Fri, 01 October 2004 12:19 Go to previous message
sai krishna
Messages: 8
Registered: July 2001
Junior Member
hello...
clearly post a form picture which ur trying to insert multiple rows......

if ur inserting through block..
then
use the loop condition.....
before going to block count the no of records in block..
then use this condition
go_block('blockname');
first_record;
loop
for i 1..n
insert into(values);
next_record;
end loop;

thank u.
sai..
Previous Topic: PLZ HELP ME ! URGENT !
Next Topic: i have three filds credit depet and palance
Goto Forum:
  


Current Time: Tue Sep 17 18:25:36 CDT 2024