Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-20 : 09:19:22
|
| Henk writes "I made some triggers which are fired when a table is changed, like this: Create Trigger [TR_CHANGED_aspect] on [aspect] FOR INSERT, UPDATE, DELETE as insert into dbTransActions.dbo.tabletransactions(updated_table, process_cell) values ('aspect', 1)Now I am using a vb application which shows a grid by using a recordset. If a change the sequence in this grid, an update of the table occurs directly, so the trigger should be fired.But I receive the following error:Err:-2147217864 QMC:Move_Up_Down : Row cannot be located for updating. Some values may have been changed since it was last read.When doing a normal update directly in the database I do not receive any errors.What should I do to prevent these errors ?" |
|
|
|
|
|
trigger fails when using recordset in vb