ev_conn_execute.asp

W3Schools tutorial..web designing

      <td>1</td>
      <td>Indicates read-only records. You cannot alter the data.</td>
    </tr>
    <tr valign="top">
      <td>adLockPessimistic</td>
      <td>2</td>
      <td>Indicates pessimistic locking, record by record. The provider does
        what is necessary to ensure successful editing of the records, usually
        by locking records at the data source immediately after editing.</td>
    </tr>
    <tr valign="top">
      <td>adLockOptimistic</td>
      <td>3</td>
      <td>Indicates optimistic locking, record by record. The provider uses
        optimistic locking, locking records only when you call the Update
        method.</td>
    </tr>
    <tr valign="top">
      <td>adLockBatchOptimistic</td>
      <td>4</td>
      <td>Indicates optimistic batch updates. Required for batch update mode.</td>
    </tr>
</table>
<br />
<hr />
<a name="commandtypeenum"><h3>CommandTypeEnum Values</h3></a>
<table cellpadding="3" width="100%" class="ex" cellspacing="0" border="1">
    <tr valign="top" align="left">
      <th width="30%">Constant</th>
      <th width="10%">Value</th>
      <th width="60%">Description</th>
    </tr>
    <tr valign="top">
      <td>adCmdUnspecified</td>
      <td>-1</td>
      <td>Does not specify the command type argument.</td>
    </tr>
    <tr valign="top">
      <td>adCmdText</td>
      <td>1</td>
      <td>Evaluates CommandText as a textual definition of a command or stored
        procedure call.</td>
    </tr>
    <tr valign="top">
      <td>adCmdTable</td>
      <td>2</td>
      <td>Evaluates CommandText as a table name whose columns are all returned
        by an internally generated SQL query.</td>
    </tr>
    <tr valign="top">
      <td>adCmdStoredProc</td>
      <td>4</td>
      <td>Evaluates CommandText as a stored procedure name.</td>
    </tr>
    <tr valign="top">
      <td>adCmdUnknown</td>
      <td>8</td>
      <td>Indicates that the type of command in the CommandText
        property is not known.</td>
    </tr>
    <tr valign="top">
      <td>adCmdFile</td>
      <td>256</td>
      <td>Evaluates CommandText as the file name of a persistently stored
        Recordset. Used with Recordset.Open or Requery only.</td>
    </tr>
    <tr valign="top">
      <td>adCmdTableDirect</td>
      <td>512</td>
      <td>Evaluates CommandText as a table name whose columns are all returned.
        Used with Recordset.Open or Requery only. To use the Seek method, the
        Recordset must be opened with adCmdTableDirect. This value cannot be
        combined with the ExecuteOptionEnum value adAsyncExecute.</td>
    </tr>
</table>
<br />
<hr />
<a name="executeoptionenum"><h3>ExecuteOptionEnum Values</h3></a>
<table cellpadding="3" width="100%" class="ex" cellspacing="0" border="1">
    <tr valign="top" align="left">
      <th width="30%">Constant</th>
      <th width="10%">Value</th>
      <th width="60%">Description</th>
    </tr>
    <tr valign="top">
      <td>adOptionUnspecified</td>
      <td>-1</td>
      <td>Indicates that the command is unspecified.</td>
    </tr>
    <tr valign="top">
      <td>adAsyncExecute</td>
      <td>16</td>
      <td>Indicates that the command should execute asynchronously. This value
        cannot be combined with the CommandTypeEnum value adCmdTableDirect.</td>
    </tr>
    <tr valign="top">
      <td>adAsyncFetch</td>
      <td>32</td>
      <td>Indicates that the remaining rows after the initial quantity specified
        in the CacheSize property should be retrieved asynchronously.</td>
    </tr>
    <tr valign="top">
      <td>adAsyncFetchNonBlocking</td>
      <td>64</td>
      <td>Indicates that the main thread never blocks while retrieving. If the
        requested row has not been retrieved, the current row automatically
        moves to the end of the file. If you open a Recordset from a Stream
        containing a persistently stored Recordset, adAsyncFetchNonBlocking will
        not have an effect; the operation will be synchronous and blocking.
        adAsynchFetchNonBlocking has no effect when the adCmdTableDirect option
        is used to open the Recordset.</td>
    </tr>
    <tr valign="top">
      <td>adExecuteNoRecords</td>
      <td>128</td>
      <td>Indicates that the command text is a command or stored procedure that
        does not return rows (for example, a command that only inserts data). If
        any rows are retrieved, they are discarded and not returned.
        adExecuteNoRecords can only be passed as an optional parameter to the
        Command or Connection Execute method.</td>
    </tr>
    <tr valign="top">
      <td>adExecuteStream</td>
      <td>256</td>
      <td>Indicates that the results of a command execution should be returned
        as a stream. adExecuteStream can only be passed as an optional parameter
        to the Command Execute method.</td>
    </tr>
    <tr valign="top">
      <td>adExecuteRecord</td>
      <td>512</td>
      <td>Indicates that the CommandText is a command or stored procedure that
        returns a single row which should be returned as a Record object.</td>
    </tr>
</table>
<br />
<hr />
<a name="eventstatusenum"><h3>EventStatusEnum Values</h3></a>
<table cellpadding="3" width="100%" class="ex" cellspacing="0" border="1">
    <tr valign="top" align="left">
      <th width="30%" valign="top">Constant</th>
      <th width="10%" valign="top">Value</th>
      <th width="60%" valign="top">Description</th>
    </tr>
    <tr>
      <td valign="top">adStatusOK</td>
      <td valign="top">1</td>
      <td valign="top">The operation that fired the event was successful</td>
    </tr>
    <tr>
      <td valign="top">adStatusErrorsOccurred</td>
      <td valign="top">2</td>
      <td valign="top">The operation that fired the event failed</td>
    </tr>
    <tr>
      <td valign="top">adStatusCantDeny</td>
      <td valign="top">3</td>
      <td valign="top">Cannot cancel the pending operation</td>
    </tr>
    <tr valign="top">
      <td valign="top">adStatusCancel</td>
      <td valign="top">4</td>
      <td valign="top">Cancels the operation that fired the event</td>
    </tr>
    <tr>
      <td valign="top">adStatusUnwantedEvent</td>
      <td valign="top">5</td>
      <td valign="top">Prevents subsequent notifications before the event method has finished
        executing</td>
    </tr>
</table>
<br />
<hr />
<a href="ado_ref_connection.asp"><img class="navup" src="../images/up.gif" alt="Connection Object Reference" border="0" /> Complete Connection Object Reference</a>

<br />
<hr />

<!-- **** SPOTLIGHTS 1 **** -->

<iframe src="../banners/aspallframe.asp" height="110" width="485"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
<hr />
<!-- **** SPOTLIGHTS 2 **** -->

<h2>Want To Be A Web Master?</h2>
<p>If you want to be a Web Master, you will have to host your web site with an ISP (Internet Service Provider).</p>
<p>MaximumASP offers seven different configurations of dedicated servers to meet your Windows and .NET hosting needs.
Hosted on our multi-tiered Enterprise Class network, these servers provide the performance, security and reliability
you need to host your high end web sites and applications. 
</p>
<p><a target="_blank" href="../../www.maximumasp.com/about/specials.aspx">Visit MaximumASP</a></p>
<hr />


<!-- **** SPOTLIGHTS 3 **** -->
<table cellpadding="0" cellspacing="0"><tr><td width="72"></td><td>
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txt*/
google_ad_slot = "1699448869";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td></tr></table>
<hr />

<center>

<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*imgtxt*/
google_ad_slot = "8606855891";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

</center>
<hr />


<!-- **** END SPOTLIGHTS **** -->

</td></tr>

<tr><td>
<p>Jump to: <a href="#top" target="_top"><b>Top of Page</b></a>
or <a href="../default.asp" target="_top"><b>HOME</b></a> or
<a href='ev_conn_execute.asp@output=print' target="_blank">
<img src="../images/print.gif" alt="Printer Friendly" border="0" />
<b>Printer friendly page</b></a></p>
<p>W3Schools provides material for training only. We do not warrant the correctness of its contents.
The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our
<a href="../about/about_copyright.asp">terms of use</a> and
<a href="../about/about_privacy.asp">privacy policy</a>.
</p>
<p><a href="../about/about_copyright.asp">Copyright 1999-2008</a> by Refsnes Data. All Rights Reserved.</p>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
<td width="60%" align="left">
<a href="../../validator.w3.org/check@uri=referer" target="_blank">
<img src="../images/vxhtml.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../jigsaw.w3.org/css-validator/check@uri=referer" target="_blank">
<img src="../images/vcss.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../www.w3.org/WAI/WCAG1A-Conformance" title="Explanation of Level A Conformance" target="_blank">
<img src="../images/wai.gif" alt="W3C-WAI level A conformance icon" width="88" height="31" border="0" /></a>
</td>
<td>
<a href="../xhtml/xhtml_howto.asp" target="_top">W3Schools was converted to XHTML in December 1999</a>
</td></tr>

</table>
</td></tr>
</table>
</td>


<td width="145" align="center" valign="top">




<iframe style="background-color:#f1f1f1" src="../banners/rightcolumn.asp@secid=ado" height="1850" width="147"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
</iframe>

</td>
</tr></table>

</body>
</html>