OraFAQ Forum: Forms » Where clause in select statement using forms 10g

Home » Developer & Programmer » Forms » Where clause in select statement using forms 10g (Forms 10g, Win Xp)

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

Where clause in select statement using forms 10g [message #438162]

Thu, 07 January 2010 05:25

mahmud732
Messages: 82
Registered: October 2009
Location: Dhaka

Member

Dear all,

How to use a where clause in forms 10g as like as Lexical paramater in Report builder.

Regards

Sultan Mahmud

Report message to a moderator

Re: Where clause in select statement using forms 10g [message #438178 is a reply to message #438162]

Thu, 07 January 2010 06:29

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Use SET_BLOCK_PROPERTY built-in and set block's DEFAULT_WHERE clause (or, possibly, ONETIME_WHERE).

Report message to a moderator

Re: Where clause in select statement using forms 10g [message #440276 is a reply to message #438162]

Thu, 21 January 2010 23:56

akagno3
Messages: 2
Registered: January 2010
Location: New Delhi

Junior Member

HI,
You can use SET_BLOCK_PROPERTY('BLOCKNAME',DEFAULT_WHERE,WHERE_CONDITION).
U can write where condition as per your requirement like Lexical Parameter.

Report message to a moderator

Previous Topic:	Validation in forms
Next Topic:	Problem in calculation in form 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:51:27 CDT 2024