Tuesday 18 August 2009

Search and Edit Form with Report

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:

Louis-Guillaume said...

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

Denes Kubicek said...

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

Louis-Guillaume said...

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.

Anonymous said...

Hello Denes,
can I get the ajax code of the search you have used in you demo application.

Thanks
Tauceef

Denes Kubicek said...

Tauceef,

Read the login page of my demo application. All the instructions are there.

Denes Kubicek