I'm using a trigger on a table, that updates that same table.
When I try to post a record to the table, the trigger does it's job, but
the application raises an exception
"the record assigned for update couldn't be located. Some values have
probably been changed since the last read operation"
(original german message: Die zum aktualisieren angegebene Zeile wurde
nicht gefunden. Einige Werte wurden seit dem letzten lesen gegebenenfalls
I know that, but how can I get ADO to concentrate on the primary key
fields of the table and present me with the updated row after the trigger
has changed it?
.... looked further: One hint I got, was to use server side cursors.
Somwhere around here I read something, that using server side cursors had
some major drawbacks.
Can anyone tell me about those, and what else I have to have in mind?