OraFAQ Forum: Forms » condition in execute query

Home » Developer & Programmer » Forms » condition in execute query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

condition in execute query [message #647523]

Sun, 31 January 2016 10:16

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

Report message to a moderator

Re: condition in execute query [message #647526 is a reply to message #647523]

Sun, 31 January 2016 15:25

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	demo.jar
Next Topic:	read, display and store image file in database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 07:55:59 CST 2025