Oracle Forms 10g 中的查询/位置对话框
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/451047/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Query/Where dialog in Oracle Forms 10g
提问by AndyDan
In Oracle Forms 6i, you could enter query mode in your form, and type &or :Ain a field, and when you executed the query, a Query/Where dialog box would open, allowing you to enter more complex query or sorting criteria than just entering data in the fields allows.
在 Oracle Forms 6i 中，您可以在表单中输入查询模式，并在字段中键入&或:A，当您执行查询时，将打开一个查询/位置对话框，允许您输入更复杂的查询或排序条件不仅仅是在字段中输入数据允许。
This doesn't seem to work in Forms 10g: I get a "FRM-40367: Invalid Criteria in field XX in example record" error.
这在 Forms 10g 中似乎不起作用：我收到“FRM-40367：示例记录中字段 XX 中的无效标准”错误。
Is there some way to do this in Oracle Forms 10g? We're running web-based, not client-server, if that matters.
在 Oracle Forms 10g 中有什么方法可以做到这一点吗？如果这很重要，我们正在运行基于网络的，而不是客户端-服务器。
回答by AndyDan
I came across the answer after I posted this question here. In 10g forms, this functionality is disabled by default, but can be enabled by setting
我在这里发布这个问题后找到了答案。在 10g 表单中，此功能默认禁用，但可以通过设置启用
FORMS_RESTRICT_ENTER_QUERY=FALSE
in the default.env file. We have now enabled this in our test environment, and it is working as expected.
在 default.env 文件中。我们现在已经在我们的测试环境中启用了它，并且它按预期工作。
回答by gareth.roberts
This functionality used to be in Oracle eBusiness Suite, but possibly was removed I think due to SQL Injection vulnerabilities. Not sure if there is a way to switch it back on - worth a look on http://metalink.oracle.com. Regards, Gareth
此功能曾经在 Oracle eBusiness Suite 中，但我认为可能由于 SQL 注入漏洞而被删除。不确定是否有办法将其重新打开 - 值得在http://metalink.oracle.com上查看。问候，加雷斯
