1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01021497"><META NAME="lcid" CONTENT="1033"><title>query Element</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>query Element</h1><div class="ofvbanav"><span class="ofvbanavreuse" id="seealso" onclick="toggleList()" onkeypress="toggleList()"></span><span class="ofvbanavreuse" id="parentelements" onclick="toggleList()" onkeypress="toggleList()"></span><span class="ofvbanavreuse" id="childelements" onclick="toggleList()" onkeypress="toggleList()"></span><span class="ofvbanavreuse" id="attributeslinks" onclick="toggleList()" onkeypress="toggleList()"></span></div><p>Associates a <a href="#" class="glossary" onclick="AppendPopup(this,'xddataadapter')" onkeypress="AppendPopup(this,'xddataadapter')">data adapter</a> with a data object or a form's underlying XML document.</p><h2>Type</h2><p><pre><code>xsd:complexType</code></pre></p><h2>Structure</h2><table>
<tr>
<th>Name</th>
<th>Description</th>
</tr>
<tr>
<td><b class="bterm"><a href="xsfelmadoAdapter.htm" id="HV01021458" lcid=" ">adoAdapter</a></b></td>
<td>(Optional element) Defines an <a href="#" class="glossary" onclick="AppendPopup(this,'ofADO')" onkeypress="AppendPopup(this,'ofADO')">ActiveX Data Objects (ADO)</a> data adapter that retrieves data from an ADO data source for the specified data object.</td>
</tr>
<tr>
<td><b class="bterm"><a href="xsfelmwebServiceAdapter.htm" id="HV01021515" lcid=" ">webServiceAdapter</a></b></td>
<td>(Optional element) Defines a Web service data adapter that retrieves data from a Web service for the specified data object.</td>
</tr>
<tr>
<td><b class="bterm"><a href="xsfelmxmlFileAdapter.htm" id="HV01021518" lcid=" ">xmlFileAdapter</a></b></td>
<td>(Optional element) Defines an .xml file data adapter that retrieves data from an .xml file for the specified data object.</td>
</tr><tr><td><a href="xsfelmqueryAction_HV01107550.htm" id="HV01107550" lcid=" "><b class="bterm">queryAction</b></a></td><td>(Optional element) Defines a data connection query action.</td></tr><tr><td><a href="xsfelmsharepointListAdapter_HV01107561.htm" id="HV01107561" lcid=" "><b class="bterm">sharepointListAdapter</b></a></td><td>(Optional element) Contains the data adapter information to query a SharePoint list or library. </td></tr>
</table><h2>Remarks</h2><p>The <b class="bterm">query</b> element is an optional element of the <b class="bterm"><a href="xsfelmxDocumentClass.htm" id="HV01021517" lcid=" ">xDocumentClass</a></b> element and the <b class="bterm"><a href="xsfelmdataObject.htm" id="HV01021464" lcid=" ">dataObject</a></b> element.</p><p>Only one data adapter can be specified in the <b class="bterm">query</b> element.</p><h2><a id="#example" name="#example">Example</a></h2><p>The following is an example of the <b class="bterm">query</b> element:</p><pre><code><xsf:<b class="bterm">query</b>>
<xsf:adoAdapter
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
Password=&quot;&quot;;User ID=Admin;
Data Source=infnwind.mdb;Mode=Share Deny None;
Extended Properties=&quot;&quot;;..."
commandText="select [EmployeeID],[LastName],[FirstName]
from [Employees] as [Employees]"
queryAllowed="yes"
submitAllowed="yes">
</xsf:adoAdapter>
</xsf:<b class="bterm">query</b>>
</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/xsfelmquery_l.htm"></iframe></span><center><a href="XMLSchemaCopyright_HV01147162.htm">©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&CTT=11&Origin=HV011232471033"
target="_new">http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp</a></center></body></html>
|
