Home » Developer & Programmer » Forms » condition in execute query
condition in execute query [message #647523] Sun, 31 January 2016 10:16 Go to next message
haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN
Senior Member
Hello friends,

Kindly help me how to use where condition in execute query.

example

customer_id customer_name Type
1 ABC PAID
2 DEF PAID
3 GHI UNPAID


Kindly guide me how to make it in oracle form when new form open show only unpaid list.


Thanks

Haider Ali
Re: condition in execute query [message #647526 is a reply to message #647523] Sun, 31 January 2016 15:25 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Put
where type = 'UNPAID'
into data block's WHERE property (in its Property Palette window). Note that this will prevent you from querying PAID type any time later. Therefore, consider creating a PRE-QUERY trigger and setting ONETIME_WHERE property using the SET_BLOCK_PROPERTY built-in.
Previous Topic: demo.jar
Next Topic: read, display and store image file in database
Goto Forum:
  


Current Time: Thu Mar 28 05:28:04 CDT 2024