0 Replies Latest reply on Apr 6, 2016 8:49 AM by Adit102

    Cannot display records in custom search form

    Adit102

      Hi,

       

      I am working on a custom form using forms 10g.

      The requirement is to search for customers or suppliers and display them in a tab canvas.

       

      Below are the steps I have done so far -

      1. Copied the QUERY_FIND from APPSTAND.fmb

      2. Added required fields in the QUERY_FIND data block and canvas.

      3. Created a datablock based on view and canvas there after. This view is returning data in the database.

      4. On the WHEN-BUTTON-PRESSED trigger in for Find button in QUERY_FIND added code, app_find.find(<above datablock name>);

       

      So far I have not added any code to filter the data from view, so when I press Find button it should display all records from the view. But it giver error 'Query caused no records to be retrieved.'

      Do I still have to give EXECUTE_QUERY, even though I have given app_find.find? If so, where do I have add it? On the when new form instance or somewhere after the Find button is clicked?

       

      Thanks,

      Aditya