Locate!

From: Atmapuri (janez.makovsek_at_usa.net)
Date: 01/21/04


Date: Wed, 21 Jan 2004 12:27:07 +0100

Hi!

I am using the Locate command to find a record.
When I add a new record to the table like this:

TAdoTable.Append;
...
TAdoTable.Post;

The Locate command raises an exception when called after post:

"Row cannot be located for updating, Some values may have changed."

The only way I found to get around this is to call

TAdoTable.Refresh;

before I call the Locate method. But Refresh operation is increadibly slow.
Is there a better way to do this?

Thanks!
Atmapuri.



Relevant Pages

  • Re: Inserting rows to a database
    ... Databasetoolbox. ... The command I'm using is: ... I'm updating my variable exdata constantly and calling insert again ...
    (comp.soft-sys.matlab)
  • Re: Updating records with SQL - saving issues
    ... in this case I'm updating 2 values: ... "login" form with name of the person and the second is the system date from ... with SQL update statement by "runSQL" command. ... everything is changing to some weird characters. ...
    (microsoft.public.access.formscoding)
  • Re: Updating forms
    ... the data in the queries that feed the form are updated ... could be an option (using a command button or so) ... To actually do some updating? ... >> control the updating of forms with new values? ...
    (microsoft.public.access.formscoding)
  • [opensuse] Updater applet error
    ... have update repo, and some others. ... All way of updating works. ... manager, with zypper from command line, but not with updater applet ... Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org ...
    (SuSE)
  • Re: Table buffering & select table conflict
    ... I am not getting you by third parameter. ... Pleae give me the command what i should write in place of what ... I am using free table for updating & fetching the record based on particulat ... use bomast inde bomast alias bomast ...
    (microsoft.public.fox.programmer.exchange)