Home » Developer & Programmer » Forms » *** Problem with Tabular form ***
*** Problem with Tabular form *** [message #78294] Mon, 11 February 2002 19:20 Go to next message
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
Re: *** Problem with Tabular form *** [message #78303 is a reply to message #78294] Tue, 12 February 2002 06:10 Go to previous messageGo to next message
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;
Thank u "pratap kumar tripathy " [message #78310 is a reply to message #78294] Tue, 12 February 2002 19:15 Go to previous message
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
Previous Topic: Re: rename a column in a table
Next Topic: Developer 2000
Goto Forum:
  


Current Time: Fri Mar 29 01:11:09 CDT 2024