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.

on

5 comments:

  1. Louis-Guillaume21 August 2009 at 03:01

    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

    ReplyDelete
  2. Denes Kubicek21 August 2009 at 10:27

    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

    ReplyDelete
  3. Louis-Guillaume21 August 2009 at 18:17

    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.

    ReplyDelete
  4. Anonymous21 May 2010 at 22:27

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

    Thanks
    Tauceef

    ReplyDelete
  5. Denes Kubicek23 May 2010 at 19:41

    Tauceef,

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

    Denes Kubicek

    ReplyDelete