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 Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|