Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Multi page submit on tabular form
Multi page submit on tabular form [message #305175] Mon, 10 March 2008 00:05 Go to next message
benseer
Messages: 22
Registered: October 2005
Location: Bangalore
Junior Member
Hi,

1) When i am pressing "Submit" on a tabular form, the changes only in the current page is getting saved , the data modified on other pages are not getting updated.
How can I resolve this?

2) If i am pressing "Add Row" , it is redirecting to Last page for a new Row , can I restrict to the active page or to the first page..

Regards,
Benseer
Re: Multi page submit on tabular form [message #305561 is a reply to message #305175] Tue, 11 March 2008 05:06 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
create a process and link to button
yours
dr.s.raghunathan
Re: Multi page submit on tabular form [message #305621 is a reply to message #305561] Tue, 11 March 2008 06:59 Go to previous messageGo to next message
benseer
Messages: 22
Registered: October 2005
Location: Bangalore
Junior Member
Hi raghunathan,

Im new into Apex, can you just provide one simple example ?

Regards,
Benseer
Re: Multi page submit on tabular form [message #305667 is a reply to message #305621] Tue, 11 March 2008 08:49 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi

In page no:11 you are storing department name in text item
(:p11_department)

In page no:12 you are storing employee name and designation
using :p12_employee_name,:p12_designation

Now you want to insert record or update using all the three
variables.

In page 11 select the text item :p11_department.
edit the properties
In which you shall able to give branching as page 12
and the value to be passed.

In page 12 just write normal sql process using
insert / update and using all the three text items defines.

you shall be successful. If not, please specify your need
with sample set of data and demo.

i try to help or i may learn from you too since it is a two way
process

yours
dr.s.raghunathan
Re: Multi page submit on tabular form [message #305680 is a reply to message #305667] Tue, 11 March 2008 09:33 Go to previous messageGo to next message
benseer
Messages: 22
Registered: October 2005
Location: Bangalore
Junior Member
Hi raghunathan,

Thanks for your reply..


But here page numbers are dynamic, (tabular form binded directly to one table) and Pagination Scheme as per the option given in Report attributes.

Here I have 4 rows per page from emp table , If i am making changes on page "1" and going to any other page and press submit, the changes done in page 1 will not be saved. The changes in the active page is getting saved.

Please find the attachement.
Re: Multi page submit on tabular form [message #305752 is a reply to message #305680] Tue, 11 March 2008 20:40 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi

still i do not face any problem. Anyway i try to stimulate
your set of data and come back to you

yours
dr.s.raghunathan
Previous Topic: Making a column mandatory
Next Topic: how to pass value between pages
Goto Forum:
  


Current Time: Thu Apr 18 16:11:20 CDT 2024