与以前一样,删除触发器不需要修改。
删除触发器不需要异常处理。
删除触发器处理程序中的下列代码行。
删除触发器不依赖于坐标值,所以这里不需要修改。
The delete trigger does not depend on the coordinate values, so nothing changes there.
清单10给出了一种方法,那就是将“删除”触发器绑定到数据模型中的节点上,然后在节点集中的节点数达到1时使该节点变为不相关。
Listing 10 shows one approach, which is to bind the "Delete" trigger to a node in the data model, and then to make that node non-relevant when the count of nodes in the set reaches 1.
注对于添加了空间列的源表,根本不需要这个触发器;一旦删除了一行,它就消失了。
NOTE in the case of a single, integrated table, this trigger is not needed at all; once a row is deleted, that's it.
请注意,如果函数、方法、触发器或视图中引用了某个全局变量,则不能删除该变量。
Please note that the global variable cannot be dropped if it is referenced in a function, method, trigger or view.
在更新触发器中,如果坐标值之一变成null,那么需要删除对应的特性。
In the update trigger, you need to delete the corresponding feature if one of the coordinates becomes null.
更新触发器比较复杂:如果更新导致异常,那么必须删除现有的特性行,就像处理null坐标一样。
The update trigger is more complicated: if the update causes an exception, you have to delete the existing feature row, just as for null coordinates.
通过侧边栏可以配置触发器动作或者删除Noteswidget。
You can configure the trigger actions and remove Notes widgets in the sidebar.
TRUNCATE 表语句此语句无需激活触发器即可快速删除整个表的内容。
TRUNCATE table statement This statement quickly deletes the contents of an entire table without firing triggers.
说明:指定删除不与现有触发器允许的规则。
原表需要一个主键或则唯一索引,因为删除的触发器需要,否则数据不会被复制。
The new table 'test'. '_online_table_new' does not have a PRIMARY KEY or a unique index which is required for the DELETE trigger.
此外,如果远程数据库已经具有所需的跟踪列、触发器和已删除项表,则将不会生成脚本。
Additionally, if the remote database already has the required tracking columns, triggers, and deleted-items table, no scripts will be generated.
某些表可能具有禁止删除操作的触发器。
如果尝试删除这类表中的行,该触发器将回滚删除操作。
If you try to delete rows from such a table, the trigger rolls back the delete.
如果您尝试删除此类表中的行,该触发器将回滚删除操作。
If you try to delete rows from such a table, the trigger rolls back the delete action.
如果您尝试删除此类表中的行,该触发器将回滚删除操作。
If you try to delete rows from such a table, the trigger rolls back the delete action.
应用推荐