Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    40

    Unanswered: Setting Multiple Options for Execute

    I'm trying to figure out how to set more than one option for

    DB.Execute - such as dbFailOnError and dbSeeChanges at the same time, but for the life of me I cannot figure out or find a reference that helps with this rather simple question. Does anyone have an answer?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    I have no idea what DB.Execute is - it certainly isn't SQL. Looks like you posted in the wrong forum!

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Larry Dumoulin
    I'm trying to figure out how to set more than one option for

    DB.Execute - such as dbFailOnError and dbSeeChanges at the same time, but for the life of me I cannot figure out or find a reference that helps with this rather simple question. Does anyone have an answer?
    DB.Execute - DAO - DB is (presumably) an instantiated DAO DAtabase object.

    Never tried for this particular object and method but since these constants are integers you can generally sum them

    Code:
     
    DB.Execute "UPDATE MyTable Set MyCol = 'MyVal'", dbFailOnError + dbSeeChanges
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •