Home » Developer & Programmer » Forms » View Query
View Query [message #181776] Tue, 11 July 2006 08:27 Go to next message
nirmalnarayan
Messages: 261
Registered: April 2005
Location: India
Senior Member
Hi,

We have a menu item in the application like 'View Query', which should function as follows, it should display the (Fieldname=Value)

i.e.,

(Code=10) in a Text box inside a modal window, this should be based on the last query fetched on the block or form.

Any idea how programmatically we can get the value and field name for which the user entered some value to be queried, once the form enters the Enter_Query mode.


Thanks n Regards,

Nirmal.
Re: View Query [message #181898 is a reply to message #181776] Wed, 12 July 2006 02:25 Go to previous message
jowahl
Messages: 82
Registered: May 2006
Member
you may enter the conditions in the PRE-QUERY trigger (SET_BLOCK_PROPERTY('<BLOCK_NAME', DEFAULT_WHERE, '<your conditions>').

it fires just before executing query independent from forms status at query time.
Previous Topic: DBMS_OUTPUT.ENABLE (100000)
Next Topic: Restrict user to choose from LOV
Goto Forum:
  


Current Time: Fri Sep 20 08:29:46 CDT 2024