Re: Row cannot be located for updating error (ADO)

From: Achot (Achot_at_xtra.co.nz)
Date: 12/30/04

  • Next message: Achot: "Re: Row cannot be located for updating. Some values may have been changed since it was last read." 
    Date: Fri, 31 Dec 2004 09:52:12 +1300

    This is answer:
    Update TableName Set Field = NewValue Where Fierld = OldValue And ...
    (Timestamp or ID)

    "Brian Bushay TeamB" <BBushay@Nmpls.com> wrote in message
    news:h879m0pvf3ic41bfve1g0b8a4mdsu3f543@4ax.com...
    >
    >>"DBEdit1 the field double clicked) in the OnDoubleClick event is writing
    >>directly to the database but the data aware controls are writing to the
    >>dataset. Am I correct in this respect?
    > Unless you are using BatchOtomistic mode when you post a record it writes
    > to the
    > dataSet. It is up to ADO to find the record in your database to update.
    >
    >> I will try the suggested change in
    >>the onShow or OnCreate form event. Is there any sense in changing is back
    >>to
    >>its default value at any stage?
    > This paragraph does not make sense to me.
    >
    > --
    > Brian Bushay (TeamB)
    > Bbushay@NMPLS.com

  • Next message: Achot: "Re: Row cannot be located for updating. Some values may have been changed since it was last read."

    Relevant Pages

    • How to do: timestamp?
      ... I save this data of the form controls into certain target path as certain ... Just after text file is created, I need to put timestamp ... Data Type in the database table field is smalldatetime. ... It would be better to use as Timestamp database servers time because ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: The Zen nature of a Delphi database application
      ... results directly to UI controls, then write data from the controls to ... then write data back from the modified objects to the DB for storage? ... I load the whole contents of the database into my business objects, ... I have dreamt of the perfect OO database application framework ...
      (comp.lang.pascal.delphi.misc)
    • Re: Concurrency Help
      ... The timestamp column is changed whenever ANY data in the row is ... >> An UPDATE operation with a focused WHERE clause is an atomic operation. ... I want to know if a database, ... >>> 1 would overwrite client 2's changes to the db. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: multiple subform images per main search form record
      ... Document ScreenDumps of: ... get a marker and label all controls with the Name property so when you ... save your word doc in the directory with the database you are documenting ... Show Images from Continuous Subform ...
      (microsoft.public.access.formscoding)
    • Re: When to (not) use the ADO data control
      ... > over is that you should use unbound controls in favor of bound controls. ... simple database program for your own use, ... > programmer that wrote the application used a mixture of DAO data controls ... I am by no means an advocate of bound controls. ...
      (microsoft.public.vb.general.discussion)