AutoCommit

imfd69_at_yahoo.com
Date: 12/24/04

  • Next message: imfd69_at_yahoo.com: "Re: AutoCommit" 
    Date: 24 Dec 2004 05:47:04 -0800

    I am writting an application in MS Access/VBA. I have an event that
    will enter information into (so far) two tables via dynamic SQL
    scripts:

    1. INSERT info. into table A
    2. INSERT info. into table B

    But, I want to somehow turn an AutoCommit off and Commit when I want it
    to commit.

    Whereas if the INSERT into table B fails for some add reason. I just
    want to exit the event and not have the INSERT into table A already
    commited. I want to commit it when all INSERTS have done their job.
    Thanks...

  • Next message: imfd69_at_yahoo.com: "Re: AutoCommit"

    Relevant Pages

    • Re: ADVERT: C12
      ... While rifles inevitably top scripts, the fools often commit inside the ... mental instances. ...
      (sci.crypt)
    • cvs-src summary for August 30 - September 6
      ... You can get old summaries, and an HTML version of this one, at ... Alan Cox changed the value of the sysctl debug.mpsafevm to ... Trouble with the CVS scripts ... Sheldon's commit had not had that line and was not rejected. ...
      (freebsd-current)
    • Re: Subversion commit from Python?
      ... scripts and was using os.system("svn commit"), ... into weird bugs with this method. ... permissions on the cgi scripts. ... handler = CGIHTTPServer.CGIHTTPRequestHandler ...
      (comp.lang.python)
    • Re: [RFC] new -stable tag variant, Git workflow question
      ... in merge commits log messages too - will your scripts notice that too? ... merge commit. ... they're not you can't generate an applyable diff). ... The slight problem is that further down, to generate the patch the ...
      (Linux-Kernel)
    • Re: Subversion commit from Python?
      ... scripts and was using os.system("svn commit"), ... of the cgi directory and plan to use a separate repository. ... f.write('Sample versioned file via python\n') ...
      (comp.lang.python)