以数据库为例,可能会使用触发器在更新行之后立即更新更改跟踪表。
In the case of a database, for example, a trigger may be used to update a change tracking table immediately after a row is updated.
通过使用上面的字段和方法,可以创建新行、更新行和删除行。
By using the fields and the methods above, you can create new rows, update them, and delete them.
然后通过调用setline将新的行写回到编辑器的缓存中,并且更新行跟踪以准备下一次遍历。
That new line is then written back to the editor buffer by calling setline , and the line tracking is updated for the next iteration.
可以通过更新行,为idssecuirtylabel类型的列指定新的安全标签,从而修改行安全标签。
Row security labels can be modified by updating the row and specifying new security label for the IDSSECUIRTYLABEL type column.
在这里,我们使用更新方法来填充新行。
对于目标表中匹配的行,将依据更新或者删除子句规范来进行更新或者删除,如图2所示。
Matched rows in the target table are updated or deleted based on update or delete clause specifications, as shown in Figure 2.
INSERT_UPDATE将新的输入数据添加到表中,或者用具有匹配主键值的输入数据更新现有的行。
INSERT_UPDATE adds new input data to the table, or updates existing rows with input data that has matching primary key values.
其次是处理需要更新的已存在的行。
不过,您可以使用乐观锁定技术循环访问一组行并单独更新每个数据行。
However, you can iterate through a set of rows and update each row individually while using optimistic locking techniques.
只有进行过更新的行具有惟一的时间戳。
Only rows that have been updated will have a unique timestamp.
更新3在where子句中使用第二个参数标志来选择要更新的行。
Update 3 also USES a second parameter marker in the WHERE clause to select the row that is updated.
第85至93行显示用于更新雇员数据的表单。
Lines 85 to 93 show the form that you can use to update the employee data.
Manager1从中选择若干行并尝试更新它们。
接下来,参赛者需要向每个表添加合适的索引,以便Informix无需扫描整个表即可找到它需要更新的行。
Next, contestants needed to add appropriate indexes to each table, so that Informix would not scan the whole table to find the row it needed to update.
那个操作成功后,该脚本调用updateauthorstable函数,使用这个新行更新显示。
When that operation is successful, it then calls the updateAuthorsTable function to update the display with the new row.
第 12-19 行用于创建或更新 @address对象。
Lines 12-19 handle creating or updating the @address object.
接下来,构造SQL命令来更新目标行,方法为使用带有WHERECURRENTOF子句的SQLupdate语句。
Next, you construct an SQL command to update the target row by using an SQL update statement, with a WHERE CURRENT OF clause.
现在,只要我们在customer表中创建、更新或删除行,就会由MDB 向WebSphereApplication Server的SystemOut.log写入一条消息。
Now whenever we create, update or delete a row in a customer table, a message will be written in SystemOut.log file of WebSphere Application Serverby MDB.
还可以使用DataAPI更新和删除行。
通过在某些方面严格限定这些更新,以确保只有那些处于最初读取状态的数据行才更新。
The update is in some way overqualified to ensure that only rows that are in the same state as those originally read are changed.
注意,这个调用将更新所有符合条件的行,而不是其中的一行。
Note also that this call will update all rows that match the criteria, not just one of them.
清单6演示了更新工作表中的行的过程。
Listing 6 illustrates the process of updating rows in a worksheet.
如果有多个数据行需要更新,则某些可能会更新成功,某些则会更新失败。
If there is a set of rows to be updated, some may be successful and some may fail.
通过使用这种方法,在对行执行选择、更新或删除操作期间,不会持有行锁。
With this approach, no locks are held between selecting and updating, or deleting a row.
要查看已更新的行,必须关闭该游标并发出一个查询来显示新结果。
To view the updated row, you must close the cursor and issue a query to display the new results.
还可以添加新行,删除和更新已有的行。
关键是准备好的语句中的sql语句会引用游标的当前位置,所以您可以多次执行它,并更新不同的行。
The key is that the SQL statement in the prepared statement references the current position of the cursor, so you can execute it multiple times and update different rows.
如果一个行已被更新或者删除,那么不能针对该行再次更新与删除,再次与任何源表联接。
If a row has already been updated or deleted, then this row cannot be joined again with any source table row for another update or delete again.
单击表格中不同的行,就会更新条形图,显示对应组件的数据。
Clicking on different rows on the table updates the bar chart to display data for the corresponding component.
单击表格中不同的行,就会更新条形图,显示对应组件的数据。
Clicking on different rows on the table updates the bar chart to display data for the corresponding component.
应用推荐