Re: Problems with a tringer


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
.

Relevant Pages

  • Problems with a tringer
    ... I am using Delphi 6, ... Trigger I have tried in the Before and After Post placing ... looked at an ADO based replacement but I can not read Russan. ... have not tried or replacement ADO tha will work and I can read? ...
    (borland.public.delphi.database.ado)
  • Re: ADO + SQL-Server + Defaultwerte
    ... Ich kann ja bei ADO allgemein auch einen String mit einem SQL-Statement ... Der Trigger reagiert auf Updates und die zu ... behandelndeRowwirdanhand einer vorher auf dem Client ...
    (microsoft.public.de.vb.datenbank)
  • Re: Row cannot be located for updating
    ... The insert/update trigger pulls information from other tables and populates ... The solution I was hoping to find was to inform ADO which fieldare the ...
    (borland.public.delphi.database.ado)
  • Re: Write conflict in ADP on updating table including triggers
    ... ADO uses the SQL Server @@IDENTITY variable to determine the key of the record ... The most obvious work-around for this is to make sure that any trigger that ... >FOR UPDATE trigger used for auditing purposes. ...
    (microsoft.public.access.adp.sqlserver)
  • Updatecommand
    ... I have a trigger that runs when updating time related data. ... Why is ADO trying to update something that was ... How I can refresh/reload the dataset which does not contain the row ...
    (microsoft.public.dotnet.framework.adonet)