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 -生---,-示--窗口