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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01105127"><META NAME="lcid" CONTENT="1033"><title>PTQuerySourceType complexType</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><h1>PTQuerySourceType complexType</h1><p>Describes the data source on which the query table or PivotTable is based.</p><h2>Type Information</h2><table>
<tr>
<td>
<b class="bterm">Namespace</b>
</td>
<td>urn:schemas-microsoft-com:office:excel</td>
</tr>
<tr>
<td>
<b class="bterm">Schema name</b>
</td>
<td>XML Spreadsheet 2000</td>
</tr>
</table><h2>Elements and Attributes</h2><h3>Child Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="xeleQueryType_PTQuerySourceType_HV01104913.htm" id="HV01104913" lcid="">QueryType</a></td>
<td>Specifies the query mechanism to use.</td>
</tr>
<tr>
<td><a href="xeleCommandText_PTQuerySourceType_HV01104486.htm" id="HV01104486" lcid="">CommandText</a></td>
<td>Specifies the text of the command to submit to the data source.</td>
</tr>
<tr>
<td><a href="xeleCommandType_PTQuerySourceType_HV01104489.htm" id="HV01104489" lcid="">CommandType</a></td>
<td>Specifies the type of command used in the CommandText element.</td>
</tr>
<tr>
<td><a href="xeleMaintain_PTQuerySourceType_HV01104725.htm" id="HV01104725" lcid="">Maintain</a></td>
<td>Specifies that a connection to the data source be left open after data is retrieved.</td>
</tr>
<tr>
<td><a href="xeleConnection_PTQuerySourceType_HV01104494.htm" id="HV01104494" lcid="">Connection</a></td>
<td>Specifies the text that defines the connection to the data source.</td>
</tr>
<tr>
<td><a href="xeleParameter_PTQuerySourceType_HV01104842.htm" id="HV01104842" lcid="">Parameter</a></td>
<td>Specifies the parameters to the command text.</td>
</tr>
<tr>
<td><a href="xeleCommandTextOrignal_HV01104488.htm" id="HV01104488" lcid="">CommandTextOrignal</a></td>
<td>Specifies the original text of the command to submit to the data source. Used only for PivotTable views when server-based page fields are used.</td>
</tr>
<tr>
<td><a href="xeleSourceConnectionFile_PTQuerySourceType_HV01104981.htm" id="HV01104981" lcid="">SourceConnectionFile</a></td>
<td>Specifies the name of the query file that was used to query the data source.</td>
</tr>
<tr>
<td><a href="xeleSourceDataFile_PTQuerySourceType_HV01104984.htm" id="HV01104984" lcid="">SourceDataFile</a></td>
<td>Contains the name of source data file (such as an .mdb file) from which the data for the PivotTable view was originally retrieved.</td>
</tr>
<tr>
<td><a href="xeleRobustConnect_PTQuerySourceType_HV01104935.htm" id="HV01104935" lcid="">RobustConnect</a></td>
<td>Contains an enumeration indicating what to do when re-establishing a connection if a refresh fails.</td>
</tr>
<tr>
<td><a href="xeleRefreshTimeSpan_PTQuerySourceType_HV01104933.htm" id="HV01104933" lcid="">RefreshTimeSpan</a></td>
<td>Specifies how often (in minutes) a PivotTable view or report should be refreshed. A value of zero indicates that timed or automatic refreshing of data is turned off.</td>
</tr>
<tr>
<td><a href="xeleLocalConnection_PTQuerySourceType_HV01104720.htm" id="HV01104720" lcid="">LocalConnection</a></td>
<td>Specifies the text that defines the connection to the local cube slice on the client computer.</td>
</tr>
<tr>
<td><a href="xeleNoRefreshCache_HV01104799.htm" id="HV01104799" lcid="">NoRefreshCache</a></td>
<td>Contains a boolean indicating if the cube can be refreshed.</td>
</tr>
<tr>
<td><a href="xeleUseLocalConnection_HV01105046.htm" id="HV01105046" lcid="">UseLocalConnection</a></td>
<td>Specifies a Boolean indicating if the user is currently using the local cube slice.</td>
</tr>
<tr>
<td><a href="xeleVersionLastEdit_PTQuerySourceType_HV01105054.htm" id="HV01105054" lcid="">VersionLastEdit</a></td>
<td>Contains a number indicating what version of Excel last edited the data from the data source.</td>
</tr>
<tr>
<td><a href="xeleVersionLastRefresh_PTQuerySourceType_HV01105056.htm" id="HV01105056" lcid="">VersionLastRefresh</a></td>
<td>Contains a number indicating what version of Excel last refreshed the PivotTable view or query.</td>
</tr>
<tr>
<td><a href="xeleVersionRefreshableMin_PTQuerySourceType_HV01105061.htm" id="HV01105061" lcid="">VersionRefreshableMin</a></td>
<td>Contains a number indicating the earliest version of Excel that can refresh the PivotTable view or query table.</td>
</tr>
</table><h3>Attributes</h3><p>None.</p><h2>Definition</h2><pre>
<code>
<xsd:complexType name="PTQuerySourceType" >
<xsd:sequence>
<xsd:element name="QueryType" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Access" />
<xsd:enumeration value="ADO" />
<xsd:enumeration value="ODBC" />
<xsd:enumeration value="OLEDB" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="CommandText" type="xsd:string" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="CommandType" default="None" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Cube" />
<xsd:enumeration value="Default" />
<xsd:enumeration value="None" />
<xsd:enumeration value="SQL" />
<xsd:enumeration value="Table" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Maintain" minOccurs="0">
</xsd:element>
<xsd:element name="Connection" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="Parameter" type="ParameterTypeE" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="CommandTextOrignal" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="SourceConnectionFile" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="SourceDataFile" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="RobustConnect" type="OneZeroType" minOccurs="0">
</xsd:element>
<xsd:element name="RefreshTimeSpan" type="xsd:integer" minOccurs="0">
</xsd:element>
<xsd:element name="LocalConnection" type="xsd:string" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="NoRefreshCache" minOccurs="0">
</xsd:element>
<xsd:element name="UseLocalConnection" minOccurs="0">
</xsd:element>
<xsd:element name="VersionLastEdit" minOccurs="0">
</xsd:element>
<xsd:element name="VersionLastRefresh" minOccurs="0">
</xsd:element>
<xsd:element name="VersionRefreshableMin" minOccurs="0">
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</code>
</pre><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>
|
