Re: Row cannot be located for updating

From: Carl (carlallen30229_at_hotmail.com)
Date: 08/17/04 

Date: Mon, 16 Aug 2004 18:12:32 -0400

After a little more research I found that it was the components that I'm
using that are the problem.

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:412053e9$1@newsgroups.borland.com...
> Do you have primary key in every table affected by delete? Deleting some
> rows may occur if there is no primary key, because ADO execute query:
>
> DELETE FROM [SomeTable] WHERE ....
>
> If there is no primary key, WHERE may select some rows.
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
> "Carl" <carlallen30229@hotmail.com> сообщил/сообщила в новостях следующее:
> news:412052ce@newsgroups.borland.com...
> > In this instance, I'm just building a desktop application. Would some
> other
> > settings be more appropriate? Should I use a server side cursor? Is
there
> a
> > way to set the SQL generation to just use the key?
> >
> > I've also seen some problems with "delete". I delete one record and when
I
> > reopen my app I find that two have been deleted instead. What would
cause
> > this?
> >
> >
> > "Brian Bushay TeamB" <BBushay@Nmpls.com> wrote in message
> > news:gf00i01rnqv2siupqa6gpdahvabagdhmcc@4ax.com...
> > >
> > > > I' using Delphi 7 with ADO components with an Access database. I
have
> > been
> > > >sporadically getting a "Row cannot be located for updating" error.
I'm
> > not
> > > >able to reproduce it, although it occurs most often when I'm trying
to
> > > >delete a record. What causes this error? What can I do to prevent it?
> > >
> > > When you use clientside cursors and make changes or delete a record in
> the
> > > client ADO needs to Generate SQL to update (or delete) the Record in
> your
> > > database. To do this it must be able to find the record in your
> database
> > that
> > > corresponds to the record you are editing.
> > > The error message you are getting indicates that ADO can not find the
> > record to
> > > be deleted.
> > > The default for ADO generating SQL is to use all the fields and values
> you
> > > originally queried from the database to find the in your database.
> > > If you have triggers that update your records or with some databases
> > DateTime
> > > fields where miliseconds get truncated the values of your
clientdataset
> > may not
> > > match the records in your database after an initial edit.
> > >
> > >
> > >
> > > --
> > > Brian Bushay (TeamB)
> > > Bbushay@NMPLS.com
> >
> >
>
>

Relevant Pages

  • Re: Select from 2 Servers
    ... where is specified the Server? ... > You don't refer to the server, you refer to the Informix instance. ... >> columns in a table except the primary key could/should be nullable. ... > and you don't have a parent row for it, just do an insert into the parent ...
    (comp.databases.informix)
  • Re: Wierd Primary Key issue
    ... the production server and then I removed the foreign key restraints. ... I have written queries to access data on linked servers using 4-part names ... The columnthat make up the primary key: ...
    (microsoft.public.sqlserver.tools)
  • Re: Join of IP Addresses not working
    ... Allen Browne - Microsoft MVP. ... server and to Excel spreadsheets. ... Primary Key. ... the Mac Address table looks like this: ...
    (microsoft.public.access.queries)
  • Re: Are lookup fields truly evil?
    ... Say you have your lookup table (* denotes the primary key field) ... PKs put on SQL Server Tables, and, as a result, had had to use unbound forms ... Evil Lookup Fields ...
    (comp.databases.ms-access)
  • Confused and needing help on error: "access" has no primary key
    ... DBI users, ... The error message (found in the Apache web server error_log file) is: ... "access" has no primary key at ... by the following PostgreSQL psql command: ...
    (perl.dbi.users)