Re: where does '129' mean in conn.execute sql, , 129

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Chris Hohmann (nospam_at_thankyou.com)
Date: 03/23/05 

Date: Tue, 22 Mar 2005 22:09:07 -0800

"Jason Chan" <no@mail.com> wrote in message
news:es8M4v2LFHA.3380@TK2MSFTNGP15.phx.gbl...
>I read aspfaq, and saw almost all execute statement have options 129
> i.e. conn.execute sql, , 129
>
> But what does 129 mean in statment?
> can I simple write conn.execute sql?
>
>
The third parameter of the ConnectionExecute method is the options
parameter. Specifically, it represents a bitmask of the CommandType and
ExecutionOption values.

129 = 1 + 128

1 = adCmdText which indicates that the command is sql text versus say a
table name or a stored procedure name.
128 = adExecuteNoRecords which indicates that the command does not return
any records which is the case for DML statements such as
UPDATE/INSERT/DELETE.

Here's a link to the documentation for the Connection.Execute method:
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthcnnexecute.asp

Relevant Pages

  • Re: Update Query Confirmation
    ... I am assuming that it is because the SQL statement is ... not sure how to refer to it in the execute statement. ... > Precede your DoCmd.RunSQL command with this code step to turn them ... >> Because it is an update query it asks for confirmation every time it ...
    (microsoft.public.access.queries)
  • Re: Command Vs Connection Object
    ... CommandType arguments in the connection's Execute statement. ... are passed to the implicit Command object. ... >> method to execute the statement, in which case an implicit Command ...
    (microsoft.public.inetserver.asp.db)
  • How to save one line of code (select command)?
    ... Does any concise-conscious programmer (spss) know how to shorten that code preferably including the execute statement in the select command. ...
    (comp.infosystems.www.authoring.html)