OraFAQ Forum: Forms » *** Problem with Tabular form ***

Home » Developer & Programmer » Forms » *** Problem with Tabular form ***

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

*** Problem with Tabular form *** [message #78294]

Mon, 11 February 2002 19:20

Robin
Messages: 73
Registered: October 2001

Member

Dear experts,
Using D2K from 6.0.5 I have manually ( not using wizad) made a tabular form having 3 row then in save button wrote 'insert into tt values (:a, :b, :c,:d)'[[ a,b,c colum name and all text field's database item property is 'no' and coloum name is ' ' ]] then commit, but it insert only content of Last row( 3rd row) of tabular form into table tt, 1st and 2nd row was ignored.
I need to insert all rows from tabular form. What should I do ? pls help

Thanks
Robin

Report message to a moderator

Re: *** Problem with Tabular form *** [message #78303 is a reply to message #78294]

Tue, 12 February 2002 06:10

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

the current record is last record.so it is inserting only one record.

write the code like this

go_block('your_block');
first_record;
loop
insert into tt values (:a, :b, :c,:d);
exit when :system.last_record='TRUE';
down;
end loop;

Report message to a moderator

Thank u "pratap kumar tripathy " [message #78310 is a reply to message #78294]

Tue, 12 February 2002 19:15

Robin
Messages: 73
Registered: October 2001

Member

Dear Sir,
Thank u 4 ur solusion, I will try according to ur advice.
Thanks again

Thanks
Robin

Report message to a moderator

Previous Topic:	Re: rename a column in a table
Next Topic:	Developer 2000

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 31 14:45:28 CST 2025