Re: Row cannot be located for updating

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

  • Next message: Viatcheslav V. Vassiliev: "Re: Row cannot be located for updating" 
    Date: Mon, 16 Aug 2004 02:23:13 -0400

    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

  • Next message: Viatcheslav V. Vassiliev: "Re: Row cannot be located for updating"

    Relevant Pages

    • Re: psycopg, transactions and multiple cursors
      ... > first time a change is made to the database. ... My intention is actually to keep them in the same transaction. ... >> cursor fetches one record from the database at a time). ... > generated from the same connection, ...
      (comp.lang.python)
    • Re: Linking to Access in VB
      ... it wrote to the database. ... I've always used ADO classic in a disconnected fashion and ... ' Client-side cursor crucial for disconnected recordset ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Best Practices
      ... How you need to abstract database from ... maybe the same command object with a different command string)? ... Try not to design an application that uses one DataReader that is connected ... > define cursor 1 ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: [VisualAge] Long lists in Client/Server application
      ... I would be able to ask the cursor to ... if it IS a database ... should switch over now to see if I have the same issue on PostgreSQL. ... query, but I can't see any easy way to position the the cursor at the ...
      (comp.lang.smalltalk)
    • Re: Row Order
      ... morphed into a flat-file design into SQL Server. ... Server is a relational database that assumes set operations and doesn't let ... > somebody doesn't want to have to add an ORDER BY clause to the cursor ...
      (microsoft.public.sqlserver.programming)