HOW TO get the queries behind a formThis is a featured page

Platform: Oracle App: Application Object Library Tool:
DB Ver: 9.2 App Ver: 11.5.8 Tool Ver:
Revision Date: 21-Oct-2005 Keywords: HOWTO, QUERY, BLOCK, FORM

Goal
To find the queries used in a form

Facts


Solution

To find the form's last executed query

  1. Go to the menu Help >> Diagnostics >> Examine
  2. EnterBlock: SYSTEM
  3. EnterItem: LAST_QUERY
  4. The value field contains the last query executed by the form

To find the query last executed in a block

  1. Go to the field on the form with the value you want
  2. Go to the menu Help >> Diagnostics >> Examine
  3. Make a note of the block
  4. Go to the menu Help >> Diagnostics >> Properties >> Item
  5. ChooseObject: Block
  6. ChooseObject 1: <the name of the block noted above>
  7. ChooseProperty: Last_query
  8. The value field contains the last query executed by the form



consultium
consultium 		Latest page update: made by consultium , Oct 6 2009, 8:52 PM EDT (about this update About This Update consultium Edited by consultium


view changes
- complete history)
Keyword tags: BLOCK FORM HOWTO QUERY
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.