• oracle form 触发器执行顺序及键定义[Z]


       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    发生错误时,显示错误窗口

  • 相关阅读:
    16 类成员
    [Tips] WSL ubuntu 18.04 安装python3
    [Tips]ubuntu安装go
    [Notes] 随笔的标题格式说明
    [Tips]Ubuntu手动修改DNS
    [BUG]Ubuntu 16.04 出现“sudo unable to resolve host”
    [Tips]ubuntu 换源
    [Tips]将本地git文件夹上传云端
    [Notes] Dockerfile中COPY命令的简单性
    [BUG]Ubuntu server 16.04安装,无网卡驱动解决
  • 原文地址:https://www.cnblogs.com/huak/p/3445356.html
Copyright © 2020-2023  润新知