Home » Developer & Programmer » Forms » hint: turn on Query/Where dialog box in Oracle forms 10.1.2.0.2 (Oracle 10g Forms Builder 10.1.2.0.2 Windows XP)
hint: turn on Query/Where dialog box in Oracle forms 10.1.2.0.2 [message #426312] Wed, 14 October 2009 19:43 Go to next message
fredg
Messages: 8
Registered: October 2009
Location: NZ
Junior Member
This is a hint for newbie who learning Oracle forms in high version with tutorial of lower version just like me.

well, it took me a while to figure out the query/where dialog box in my practice and I reckon it worths me to leave info here for someone.

In Oracle Forms 10.1.2.0.2, if you ENTER QUERY then input symbol like :S or & then you EXECUTE QUERY, it won't popup the dialog box because this feature has been locked defaultly.

To tunn on this feature, you should adjust the parameter in file Default.env
the path should be similar like mine

C:\oracle\DevSuiteHome_1\forms\server\default.env

*******BEFORE*************

FORMS_RESTRICT_ENTER_QUERY=TRUE


*******AFTER*************

FORMS_RESTRICT_ENTER_QUERY=FALSE


then the dialog box should popup once you re-execute your form.

Cheers
Re: hint: turn on Query/Where dialog box in Oracle forms 10.1.2.0.2 [message #428315 is a reply to message #426312] Tue, 27 October 2009 18:42 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Is your startup trying to open the form in 'query_only' mode?

David
Re: hint: turn on Query/Where dialog box in Oracle forms 10.1.2.0.2 [message #428417 is a reply to message #428315] Wed, 28 October 2009 04:59 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I believe that he just wanted to share what he has discovered (i.e. there's no question here).
Previous Topic: Registry Error
Next Topic: error while running reports
Goto Forum:
  


Current Time: Fri Sep 20 06:59:12 CDT 2024