Setting Multiple Options for Execute

Larry Dumoulin · #1 (**permalink**) 09-21-05, 17:26

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?

andrewst · #2 (**permalink**) 09-22-05, 12:35

I have no idea what DB.Execute is - it certainly isn't SQL. Looks like you posted in the wrong forum!

pootle flump · #3 (**permalink**) 09-23-05, 09:27

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

Internet Services

Web Development

Digital Marketing

Consumer Tech