record not found after post with trigger in DB

record not found after post with trigger in DB

Post by Lutz Kutsc » Thu, 04 Nov 2004 02:08:42


Hi,

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
gedert)

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?

Thanks,
Lutz
 
 
 

record not found after post with trigger in DB

Post by Vitali Kal » Thu, 04 Nov 2004 02:16:21

Put SET NOCOUNT ON in yours trigger