Re: Problems with a tringer

Yes I it is modify the Key and I dont own the trigger to modify it. So can I
do a server side cursor? I have never done it before what is the
ramifications?

Thanks for the responce
Donald S. Bossen

"Brian Bushay TeamB" <BBushay@xxxxxxxxx> wrote in message
news:2s6804dikmimqaka0rvqmhpssnqa86hmd4@xxxxxxxxxx

I am getting the Following error "Row cannot be located for update. Some
vales may have been changed sine it was last read. I am using Delphi 6, on
SQL 2005 Database with the standard ADO tools that came with Delph and a
TAdoDataSet Component. The Error occurs when post is called. I have read
the
google posting. I have tried adding SET NOCOUNT ON to the begining of the
Trigger I have tried in the Before and After Post placing
TBL.Properties['Update Criteria'].value := adCriteriaKey all with no luck
I
looked at an ADO based replacement but I can not read Russan. Any thing i
have not tried or replacement ADO tha will work and I can read?

What is your trigger doing?
It sounds like it is modifying a value in the key and that is never going
to be
compatible with editing from a clientside cursor.
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx


.