Home » Developer & Programmer » Forms » Where clause in select statement using forms 10g (Forms 10g, Win Xp)
Where clause in select statement using forms 10g [message #438162] Thu, 07 January 2010 05:25 Go to next message
mahmud732
Messages: 74
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
Re: Where clause in select statement using forms 10g [message #438178 is a reply to message #438162] Thu, 07 January 2010 06:29 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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).
Re: Where clause in select statement using forms 10g [message #440276 is a reply to message #438162] Thu, 21 January 2010 23:56 Go to previous message
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.
Previous Topic: Validation in forms
Next Topic: Problem in calculation in form 6i
Goto Forum:
  


Current Time: Sat Dec 03 12:29:36 CST 2016

Total time taken to generate the page: 0.14951 seconds