It is easy to create a form with a report in order to drill-down and modify or create records. It would be great if Apex would have a wizard for creating a form which would give us a possibility not only to edit and create records but also to search on those. In this small example in my Demo Application you can see how to do that manually. This example shows several things:
- how to create a manual form
- how to create a manual fetch process
- how to ensure data integrity using checksum
- how to create a form for editing and searching data
- how to drill down on a record set returned by a search without loosing it
Enjoy.
5 comments:
Hi Denes,
I think you should do a "select for update" when validating the checksum.
That's a big demo site you have there! :P
Louis-Guillaume
Louis-Guillaume,
I know - in this example I show how to do that:
http://apex.oracle.com/pls/otn/f?p=31517:170
I skipped that in this example intentionally since contained in the section of tabular forms.
Yes, the demo application is the biggest and the most popular one. With over 1400 registered users.
Denes Kubicek
On your demo site, maybe you can add a section with links to "linked demos".
It would help those who didn't saw or remember all your demos.
Hello Denes,
can I get the ajax code of the search you have used in you demo application.
Thanks
Tauceef
Tauceef,
Read the login page of my demo application. All the instructions are there.
Denes Kubicek
Post a Comment