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?
Thanks in Advance
Donald S. Bossen


.

Relevant Pages

  • Re: Problems with a tringer
    ... 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: Delphi 8 and ado.net
    ... > different to using say ADO in Delphi? ... The Delphi ADO implementation is basically a wrapper around the Recordset ... have cursors into the database, there are no cursors in ADO.NET. ...
    (borland.public.delphi.non-technical)
  • Re: Sub Selects?
    ... > some nice Delphi DB technique to do this, or should I just build up the ... Due to the way that the ado ... lets assume that you have a list called SelectedIds ... I'd recommend against using the filtering method. ...
    (borland.public.delphi.database.ado)
  • Re: recursive sp, fmtonly, ado,
    ... This was the first thing I've checked, because I suspect Delphi. ... It's in somewhere inside ADO or OLEDB. ... >> create procedure fmttest ...
    (microsoft.public.sqlserver.programming)
  • Re: Field position in a record, how to change?
    ... If you know how to move fields with DAO you can use Ole to access the ... I have found how to obtain the (ADO) FieldDefs for the ... (I am searching documentations for this option but your answer might ... I may just have found the answer in my saved Delphi 5 help files ...
    (borland.public.delphi.database.ado)