• FORM触发器执行顺序


    触发器执行顺序:

    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-INSTANC

    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

  • 相关阅读:
    C++函数模板的显示调用与隐式调用
    git显示颜色配置
    STL容器元素应满足的条件
    vector缩减容量
    PAT (Basic Level) Practise:1036. 跟奥巴马一起编程
    Core Java Volume I — 4.10. Class Design Hints
    Core Java Volume I — 4.7. Packages
    蓝牙(Profile)构成
    Android开发之Java必备基础
    主机控制器接口(HCI)
  • 原文地址:https://www.cnblogs.com/bruce_zhao/p/3810241.html
Copyright © 2020-2023  润新知