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: The easiest framework for Java Database applications development released for production use
      ... Yaormama has been deployed and proven ... ... Basically it encapsulates the boilerplate code that opens the cursor ... on the database side. ...
      (comp.lang.java.programmer)
    • 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)