met_comm_execute.asp

W3Schools tutorial..web designing

    </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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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 href="ado_ref_command.asp"><img class="navup" src="../images/up.gif" alt="Command Object Reference" border="0" /> Complete Command 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>Learn XML with &lt;oXygen/> XML Editor - Free Trial!</h2>
<table cellpadding="0"><tr>
<td valign="top"><a target="_blank" href="../../www.oxygenxml.com/default.htm">
<img src="../images/oxygenxml.png" border="0" alt="oXygen - Probably The World's Best XML Editor" /></a></td>
<td>&nbsp;&nbsp;</td>
<td valign="top">
<p><a href="../../www.oxygenxml.com/default.htm" target="_blank">oXygen</a> helps you learn to define,
edit, validate and transform XML documents. Supported technologies include XML Schema,
DTD, Relax NG, XSLT, XPath, XQuery, CSS.</p>
<p>Understand in no time how XSLT and XQuery work by using the intuitive oXygen debugger!</p>
<p>Do you have any XML related questions? Get free answers from the oXygen
<a href="../../www.oxygenxml.com/forum/default.htm" target="_blank">XML forum</a>
and from the <a href="../../www.oxygenxml.com/documentation.html" target="_blank">video</a>
demonstrations.</p>
<p><b><a href="../../www.oxygenxml.com/download.html" target="_blank">
Download a FREE 30-day trial today!</a></b></p>
</td></tr></table>
<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='met_comm_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>