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: 10180
Registered: March 2005
Location: Canberra ACT 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: 20827
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: Thu Sep 29 07:23:32 CDT 2016

Total time taken to generate the page: 0.05017 seconds