File: xsfatrcommandText.htm

package info (click to toggle)
office2003-schemas 1.0%2Bds-1
  • links: PTS, VCS
  • area: non-free
  • in suites: bookworm, forky, sid, trixie
  • size: 42,304 kB
  • sloc: javascript: 2,429; makefile: 29
file content (21 lines) | stat: -rw-r--r-- 2,884 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01021537"><META NAME="lcid" CONTENT="1033"><title>commandText Attribute</title><link rel="stylesheet" type="text/css" href="office10.css"><script type="text/javascript" language="Javascript" src="ExpCollapse.js"></script><script type="text/javascript" language="JavaScript" src="inline.js"></script></head><body><p id="ExpandAllLine" class="ExpFav"><a href="#" onclick="ExpandAll()" onkeypress="ExpandAll()" class="DropDown"><img id="picHeader" border="0" src="expandtri.gif" alt="Show All"><span id="ExpandAll">Show All</span></a></p><h1>commandText Attribute</h1><div class="ofvbanav"><span class="ofvbanavreuse" id="seealso" onclick="toggleList()" onkeypress="toggleList()"></span><span class="ofvbanavreuse" id="parentelements" onclick="toggleList()" onkeypress="toggleList()"></span></div><p>A string property that contains the <a href="#" class="glossary" onclick="AppendPopup(this,'ofADO')" onkeypress="AppendPopup(this,'ofADO')">ActiveX Data Objects (ADO)</a> SQL command text to be used for querying the data from the specified data source.</p><h2>Type</h2><p><pre><code>xsd:string</code></pre></p><h2>Remarks</h2><p>The <b class="bterm">commandText</b> attribute is a required attribute of the <b class="bterm"><a href="xsfelmadoAdapter.htm" id="HV01021458" lcid=" ">adoAdapter</a></b> element.</p><h2><a id="#example" name="#example">Example</a></h2><p>The following is an example of the <b class="bterm">commandText</b> attribute as it is used in the <b class="bterm">adoAdapter</b> element:</p><pre><code>&lt;xsf:query&gt;
   &lt;xsf:adoAdapter 
      connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
         Password=&amp;quot;&amp;quot;;User ID=Admin;
         Data Source=infnwind.mdb;Mode=Share Deny None;
         Extended Properties=&amp;quot;&amp;quot;;..."
      <b class="bterm">commandText</b>="select [EmployeeID],[LastName],[FirstName] 
         from [Employees] as [Employees]" 
      queryAllowed="yes"
      submitAllowed="yes"&gt;
   &lt;/xsf:adoAdapter&gt;
&lt;/xsf:query&gt;
</code></pre><script type="text/javascript" language="JScript" src="ofvbanl.js"></script><span id="ofVBAISpan" class="ofvbaispan"><iframe id="ofVBAIFrame" frameborder="0" marginheight="0" marginwidth="4" scrolling="auto" width="100%" src="../links/xsfatrcommandText_l.htm"></iframe></span><center><a href="XMLSchemaCopyright_HV01147162.htm">&copy;2003-2004 Microsoft Corporation. All rights reserved.</a>  

Permission to copy, display and distribute this document is available at: <a 

href="http://r.office.microsoft.com/r/rlidAWSContentRedir?AssetID=XT010988631033&amp;CTT=11&amp;Origin=HV011232471033" 

target="_new">http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp</a></center></body></html>