oracleform触发器执行顺序及键定义

1-打-FORM-:
  (1)PRE-FORM

  (2)PRE-BLOCK(BLOCK-)

  (3)WHEN-NEW-FORM-INSTANCE

  (4)WHEN-NEW-BLOCK-INSTANCE

  (5)WHEN-NEW-RECORD-INSTANCE

  (6)WHEN-NEW-ITEM-INSTANCE

  2. -填-一行--完成后,光-移-到下一---的-候:

  (1)WHEN-VALIDATE-RECORD

  (只-填-的--与-据-中已存在的--作唯一性的--,如果只是-面上的-据重复而-据-中-有与其重复的值-不---.)

  (2)WHEN-NEW-RECORD-INSTANCE

  (3)WHEN-NEW-ITEM-INSTANCE

  3. ---“保存”-

  (1)WHEN-VALIDATE-RECORD

  (--面上的所有-据提交到-据-,若-面上有重复的-据,-提交第一次-成功但只是--据先-到-据-中一-似--表的地方,在提交第二-重复--的-候--,-行事-回-,原--行成功的指令也-被撤消)

  (2)PRE-INSERT

  (3)ON-INSERT

  (4)POST-INSERT

  (5)POST-FORMS-COMMIT

  (6)PRE-BLOCK(BLOCK-)

  (7)KEY-COMMIT

  (8)WHEN-NEW-ITEM-INSTANCE

  4.-光-移-到-前-据-中已--示的行上-:

  (1)WHEN-REMOVE-RECORD

  (2)WHEN-NEW-RECORD-INSTANCE

  (3)WHEN-NEW-ITEM-INSTANCE

  -在-行上的不同ITEM移--:

  (4)WHEN-NEW-ITEM-INSTANCE

  5.-要-行修改-(在--中的某--上-行了修改-):

  (1)ON-LOCK

 6.在修改完成后-行保存-:

  (1)WHEN-VALIDATE-RECORD

  (2)PRE-UPDATE

  (3)ON-UPDATE

  (4)POST-FORMS-COMMIT

  (5)PRE-BLOCK(BLOCK-)

  (6)KEY-COMMIT

  (7)WHEN-NEW-ITEM-INSTANCE

  7.-除一----:

  (1)ON-LOCK

  (2)WHEN-REMOVE-RECORD

  (3)KEY-DELREC

  (4)WHEN-NEW-RECORD-INSTANCE

  (5)WHEN-NEW-ITEM-INSTANCE

  8.F11查--程:

  (1)WHEN-CLEAR-BLOCK

  (2)WHEN-NEW-RECORD-INSTANCE

  (3)WHEN-NEW-ITEM-INSTANCE

  在-入查--件后-CTRL+F11:

  (4)PRE-QUERY

  (5)WHEN-CLEAR-BLOCK

  (6)POST-QUERY

  (7)WHEN-NEW-RECORD-INSTANCE

  (8)WHEN-NEW-ITEM-INSTANCE

  9.CRRL+F11:

  (1)WHEN-CLEAR-BLOCK

  (2)PRE-QUERY

  (3)WHEN-CLEAR-BLOCK

  (4)   POST-QUERY(每查一---,触-一次)

  (5)WHEN-NEW-RECORD-INSTANCE

  (6)WHEN-NEW-ITEM-INSTANCE

 10.-查---(F11)---入--(F4)-:

  (1)WHEN-CLEAR-BLOCK

  (2)KEY-EXIT

  (3)WHEN-NEW-RECORD-INSTANCE

  (4)WHEN-NEW-ITEM-INSTANCE

  11.手-筒查--程:

  (1)QUERY_FIND(BLOCK-)

  -入查--件后,--“查-”按-:

  (2)WHEN-CLEAR-BLOCK

  (3)PRE-QUERY

  (4)WHEN-CLEAR-BLOCK

  (5)POST-QUERY

  (6)WHEN-NEW-RECORD-INSTANCE

  (7)WHEN-NEW-ITEM-INSTANCE

  12.--“New”-:

  (1)WHEN-NEW-RECORD-INSTANCE

  (2)WHEN-NEW-ITEM-INSTANCE

  13.--“Edit Field”-:

  (1)KEY-EDIT

  14.--“Window Help”-:

  (1)KEY-HELP

  15.--“Clear Record”-:

  (1)WHEN-REMOVE-RECORD

  (2)POST-QUERY

  (3)WHEN-NEW-RECORD-INSTANCE

  (4)WHEN-NEW-ITEM-INSTANCE

  16.--F4---:

  (1)KEY-EXIT

  (2)POST-FORM

  17.--“Close Form”按----:

  (1)KEY-EXIT

  (2)POST-FORM

  18. --“Translations”按--:

  (1)TRANSLATIONS

 19.--小叉----:

  (1)WHEN-WINDOW-CLOSED

  (2)CLOSE-WINDOW

  (3)KEY-EXIT

  (4)POST-FORM

  20.-中LOV列表:

  (1)KEY-LISTVAL

  (2)WHEN-NEW-ITEM-INSTANCE

  21.-中--前面的小--:

  (1)WHEN-NEW-RECORD-INSTANCE

  (2)WHEN-NEW-ITEM-INSTANCE(-据--)

  (3)WHEN-NEW-ITEM-INSTANCE

  22.光-上下移--

  (1)WHEN-NEW-RECORD-INSTANCE

  (2)WHEN-NEW-ITEM-INSTANCE

  ORACLE FORM key+fn触-器

  Developer/2000中各--触-子所--的“按-”

  Form程序:

  封--程    -触-子 含-          --按-
  ABORT_QUERY   Key-EXIT [退出/取消]
  BLOCK_MENU   Key-MENU [-菜-]        F5
  CLEAR_BLOCK   Key-CLRBLK [清空-]        Shift+F5
  CLEAR_FORM   Key-CLRFRM [清空FORM]       Shift+F7
  CLEAR_RECORD  Key-CLRREC [清空--]       Shift+F4
  COMMIT_FORM   Key-COMMIT [提交/存-]       F10
  COUNT_QUERY   Key-CQUERY [-算查-----]   Shift+F2

CREATE_RECORD  Key-CREREC [插入新--]      F6
  DELETE_RECORD  Key-DELREC [-除--]       Shift+F6
  DOWN      Key-DOWN [下---]       Ctrl+l、下箭-
  DUPLICATE_ITEM Key-DUP-ITEM [复制域/-]       F3
  DUPLICATE_RECORDKey-DUPREC [复制--]       F4
  EDIT_TEXTITEM  Key-EDIT [打---器]      Ctrl+E
  ENTER      Key-ENTER [Enter]
  ENTER_QUERY   Key-ENTQRY [-入查--件]     F7
  EXECUTE_QUERY  Key-EXEQRY [-行查-]       F8
  EXIT_FORM    Key-EXIT [退出/取消查-]     Ctrl+Q
  HELP      Key-HELP [-助]         F1
  LIST_VALUES   Key-LISTVAL [-示值列表LOV]     F9
  LOCK_RECORD   Key-UPDREC [Lock Record]
  NEXT_BLOCK   Key-NXTBLK [下一-]        Ctrl+Page Down
  NEXT_ITEM    Key-NEXT-ITEM [下一域/-]       Ctrl+Tab、Tab、Enter
  NEXT_KEY    Key-NXTKEY [定位到下一-主--]  Shift+F3
  NEXT_RECORD   Key-NXTREC [下一---]      Shift+Down
  NEXT_SET    Key-NXTSET [下一---集]     Ctrl+>
  PREVIOUS_BLOCK Key-PRVBLK [前一-]        Ctrl+Page Up
  PREVIOUS_ITEM  Key-PREV-ITEM [前一域/-]       Shift+Tab、Shift+Ctrl+Tab
  PREVIOUS_RECORD Key-PRVREC [前一---]      Shift+Up
  PRINT      Key-PRINT [打印-前屏幕]     Shift+F8
  SCROLL_DOWN   Key-SCRDOWN [下翻屏]        Page Down
  SCROLL_UP    Key-SCRUP [上翻屏]        Page Up
  UP       Key-UP     [上---]       Ctrl+p、上箭-

  Esc       取消
  Backspace    向后-除
  Ctrl+U     清除域/-
  Ctrl+F1     -示有效的功能-列表
  Shift+F1    -生---,-示--窗口

  Esc取消

  Backspace向后-除

  Ctrl+U清除域/-

  Ctrl+F1-示有效的功能-列表

  Shift+F1    -生---,-示--窗口

原文地址:https://www.cnblogs.com/toowang/p/2321773.html