Silly Question - SQL conn.execute

[michaaal]

I feel a bit silly asking this because I use this code all the time, but
what does the ",,129" mean? Are there other parameters that one might use
(I only do fairly simple SQL commands).

conn.execute strSQL,,129

[Bob Barrows [MVP]]

michaaal wrote:

I feel a bit silly asking this because I use this code all the time,
but what does the ",,129" mean? Are there other parameters that one
might use (I only do fairly simple SQL commands).

conn.execute strSQL,,129

The ADO online help can be found here:
http://msdn.microsoft.com/library/en...dooverview.asp

There are two versions of the Execute command.
The Command object's Execute method:
command.Execute RecordsAffected, Parameters, Options

and the Connection object's Execute method:
connection.Execute CommandText, RecordsAffected, Options

Notice that they both have an Options argument. This argument is " ... A
Long value that indicates how the provider should evaluate the CommandText
argument. Can be a bitmask of one or more CommandTypeEnum or
ExecuteOptionEnum values."

You can specify more than one value by adding them together. 129 is the
combination of two values: 1 and 128.

The 1 is enumerated by the adCmdText constant and tells the provider to
treat the CommandText as a string containing a SQL statement. You should
always provide the CommandType option - don't make the provider guess what
the command type is: it wastes programming cycles and, in rare instances, it
can make the wrong guess.

The 128 is enumerated by adExecuteNoRecords, and tells the provider not to
construct a recordset object because the query being executed will not
return any records.

I will leave it up to you to look in the online help and find the other
possible values allowed for the Options argument.

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[michaaal]

You're the best, Bob.