Re: BatchOptimistic Locking

From: JS (js_at_somewhere.com)
Date: 03/25/04 

Date: Thu, 25 Mar 2004 11:19:49 +0700

thanks for your response,

but i think adRecDBDeleted is set if we try to delete a record in rs which
is already deleted in the database.

my problem is i have a disconnected rs, thus any changes in database made by
others
is possible and it will not immediately reflected in my rs. so the records
in the rs is
possibly not syncronize with the underlying record in database.

i have tried to call updatebatch to commit my changes (not include delete
action, just
modification of records value) and it will raise an error (as i expected) if
the records
in the database has been changed since it was last read.

the second case is i delete a record in rs, but it does not raise an error
if the records
in the database has been changed since it was last read.

is it the way it work or i have miss something ?

Relevant Pages

  • Re: BatchOptimistic Locking
    ... indicate the row may be deleted (and filters flagged rows from user view) ... rather than actually deleting it. ... > is already deleted in the database. ... > the second case is i delete a record in rs, but it does not raise an error ...
    (microsoft.public.data.ado)
  • dynamic tables with Ajax
    ... The page has a Buton that add new row ... in the database. ... The exception is raise on line "tableProt.Rows.Add". ... Exits other form?? ...
    (microsoft.public.dotnet.languages.csharp)
  • newbie: detect new record automatically?
    ... is it possible for a database like access or msde or sql server ... express to raise an event to an application? ... record exists in the database in as close to real time, ...
    (microsoft.public.vb.database)
  • Classicat website moribund?
    ... or otherwise moribund; I can't raise ... If you have been using ClassiCat, ... the database recently, delay may be contraindicated. ...
    (rec.music.classical.recordings)
  • Re: [PHP] A no brainer...
    ... that once you commit, the data is there no matter what. ... Unless session storage is used to save time in retrieving data, ... I think it would be kind of fun to run some actual tests. ... it makes no sense for a database to be faster than ...
    (php.general)