ITPub博客

首页 > 数据库 > Oracle > ENTER-QUERY Mode

ENTER-QUERY Mode

原创 Oracle 作者:pan_tian 时间:2014-07-02 13:55:46 0 删除 编辑
SYSTEM.MODE indicates whether the form is in Normal, Enter Query, or Fetch Processing mode. The value is always a character string.

* NORMAL - Indicates that the form is currently in normal processing mode.

* ENTER-QUERY - Indicates that the form is currently in Enter Query mode.

* QUERY - Indicates that the form is currently in fetch processing mode, meaning th

1.After pressing F11, Then system will switch to ENTER-QUERY mode.

2.If you hit Ctrl+F11, system will execute query,and retrieve records to you,system mode will turn back to \'NORMAL\'




Sample Code for enter query:

Consider the following When-Button-Pressed trigger for the Query button.If the operator clicks the button in Normal mode, the trigger places the form in Enter-Query mode (using the ENTER_QUERY built-in). Otherwise, if already in Enter-Query mode, the button executes the query (using the EXECUTE_QUERY built-in).

IF :SYSTEM.MODE = \'NORMAL\' THEN
  ENTER_QUERY;
ELSE
  EXECUTE_QUERY;
END IF;


<!-- Baidu Button BEGIN -->

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26687597/viewspace-1204283/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: Hidden Methods to Query Oracle Apps Forms -- Very Useful
下一篇: SQL*Plus FAQ
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2012-02-18

最新文章