Re: Delete record in batch mode

From: "Bill Todd" <no@xxxxxx>
Date: 28 May 2007 12:33:16 -0700

Cavalera Guido wrote:

...But in insert and update all fine, while in DELETE i.ve an error
'row cannot be located for updating ...'

WHY ? help me please !

I assume the problem is that ADO has no whay to find the record in
OrdPro since you do not include its primary key field(s) in the SELECT
clause.

--
Bill Todd (TeamB)
.

Follow-Ups:
- Re: Delete record in batch mode
  - From: Cavalera Guido

References:
- Delete record in batch mode
  - From: Cavalera Guido
- Re: Delete record in batch mode
  - From: Cavalera Guido

Prev by Date: Re: Delete record in batch mode
Next by Date: Re: Delete record in batch mode
Previous by thread: Re: Delete record in batch mode
Next by thread: Re: Delete record in batch mode
Index(es):
- Date
- Thread

Relevant Pages

Re: Delete record in batch mode
... Cavalera Guido wrote: ... MS Access does not use ADO so its behavior is not relevant to your ... Bill Todd (TeamB) ...
(borland.public.delphi.database.ado)
Row cannot be located for updating. Some values may have been changed since it was last read.
... Ado with msSql2000. ... Exception: ... Row cannot be located for updating. ... Daniel Fagnan ...
(borland.public.delphi.database.ado)
Re: Slow update
... How many records are you updating? ... between you and the SQL database? ... > I hope you'll forgive me for posting this here (I've also posted to ado ... > site but with no response so far) as I'm urgently after a solution. ...
(microsoft.public.dotnet.languages.vb)
Refreshing links of an MDB
... Is it possible to refresh the path of linked tables using ADO? ... I've tried updating the records in MSysObjects but I don't have permission ...
(microsoft.public.vb.database.ado)
Re: Usgin CashedUpdates mechanism for ADO and dbExpress Components
... I want a way to using an UpdateObject for updating my ADO application's ... > Good luck, ...
(borland.public.delphi.database.ado)