Hello Everybody. I'm using disconnected recordset to update SQL Server 7.0
. Recordset.UpdateBatch worked fine 'till I wrote a trigger for that table.
Now it fails with an error "Row can not be located for update, or values
in database have changed". I wrote SQL update statement to check the trigger
and it worked. I did an AddNew with the mechanism and trigger in place and
it worked (I guess there were no values to compare for recordset). Any workarounds
or suggestions?
Regards, Alex.