<?xml version="1.0" encoding="UTF-8"?>
<structure version="14" html-doctype="HTML4 Transitional" compatibility-view="IE9" relativeto="*SPS" encodinghtml="UTF-8" encodingrtf="ISO-8859-1" encodingpdf="UTF-8" useimportschema="1" embed-images="1" enable-authentic-scripts="1" authentic-scripts-in-debug-mode-external="0" generated-file-location="DEFAULT">
	<parameters/>
	<schemasources>
		<namespaces/>
		<schemasources>
			<dbschemasource name="DB" main="1">
				<database_connection database_kind="MS Access" import_kind="ADO" version="04.00.0000" name="DailySharePrices" active="1" use_driver_for_retrieval="1">
					<properties>
						<property name="Database Kind" value="MS Access"/>
						<property name="Import Kind" value="ADO"/>
						<property name="Root Object" value="DailySharePrices"/>
						<property name="Data Source" value="DailySharePrices.mdb"/>
						<property name="Provider" value="Microsoft.Jet.OLEDB.4.0"/>
						<property name="User ID"/>
						<property name="Password"/>
						<property name="Persist Security Info"/>
						<property name="Jet OLEDB:System Database"/>
						<property name="Jet OLEDB:Sandbox Mode"/>
						<property name="Jet OLEDB:Exclusive Async Delay"/>
						<property name="Jet OLEDB:Flush Transaction Timeout"/>
						<property name="Jet OLEDB:Implicit Commit Sync"/>
						<property name="Jet OLEDB:Lock Delay"/>
						<property name="Jet OLEDB:Lock Retry"/>
						<property name="Jet OLEDB:Max Buffer Size"/>
						<property name="Jet OLEDB:Max Locks Per File"/>
						<property name="Jet OLEDB:Page Locks to Table Lock"/>
						<property name="Jet OLEDB:Page Timeout"/>
						<property name="Jet OLEDB:Recycle Long-Valued Pages"/>
						<property name="Jet OLEDB:Shared Async Delay"/>
						<property name="Jet OLEDB:User Commit Sync"/>
						<property name="Jet OLEDB:Compact Without Replica Repair"/>
						<property name="Jet OLEDB:Create System Database"/>
						<property name="Jet OLEDB:Database Locking Mode"/>
						<property name="Jet OLEDB:Database Password"/>
						<property name="Jet OLEDB:New Database Password"/>
						<property name="Jet OLEDB:Registry Path"/>
					</properties>
					<LocalViewStorage>
						<LocalViewElement SQL="SELECT Format ([Date], &quot;mm/dd&quot;),
       [Open],
       [High],
       [Low],
       [Close]
FROM   [SharesTable]
WHERE  [Company] = &apos;Nanonull&apos;
AND ([Date] &gt;= DateValue (&quot;11/1/2010&quot;) AND [Date] &lt; DateValue (&quot;11/20/2010&quot;))
ORDER BY [Date] ASC; ">
							<PathElement Name="DailySharePrices" Kind="DataSource"/>
							<PathElement Name="DailySharePrices" Kind="Database"/>
							<PathElement Name="SELECT_Prices_For_Duration" Kind="Select Statement"/>
						</LocalViewElement>
						<LocalViewElement SQL="SELECT Format ([Date], &quot;mm/dd&quot;),
       [Open],
       [High],
       [Low],
       [Close],
       [Volume] / 100000 AS Volume
FROM   [SharesTable]
WHERE  [Company] = &apos;Nanonull&apos;
AND ([Date] &gt;= DateValue (&quot;11/1/2010&quot;) AND [Date] &lt; DateValue (&quot;11/20/2010&quot;))
ORDER BY [Date] ASC;">
							<PathElement Name="DailySharePrices" Kind="DataSource"/>
							<PathElement Name="DailySharePrices" Kind="Database"/>
							<PathElement Name="SELECT_Share_Sales_For_Duration" Kind="Select Statement"/>
						</LocalViewElement>
						<LocalViewElement SQL="SELECT Format ([Date], &quot;mm/dd&quot;),
       [Volume] / 100000 AS Volume
FROM   [SharesTable]
WHERE  [Company] = &apos;Nanonull&apos;
AND ([Date] &gt;= DateValue (&quot;11/1/2010&quot;) AND [Date] &lt; DateValue (&quot;11/20/2010&quot;))
ORDER BY [Date] ASC;">
							<PathElement Name="DailySharePrices" Kind="DataSource"/>
							<PathElement Name="DailySharePrices" Kind="Database"/>
							<PathElement Name="SELECT_Volumes_For_Duration" Kind="Select Statement"/>
						</LocalViewElement>
					</LocalViewStorage>
					<LocalRelationsStorage/>
				</database_connection>
				<dbselectedtablesandviews>
					<dbobject>
						<PathElement Name="DailySharePrices" Kind="DataSource"/>
						<PathElement Name="DailySharePrices" Kind="Database"/>
						<PathElement Name="SELECT_Share_Sales_For_Duration" Kind="Select Statement"/>
					</dbobject>
					<dbobject>
						<PathElement Name="DailySharePrices" Kind="DataSource"/>
						<PathElement Name="DailySharePrices" Kind="Database"/>
						<PathElement Name="SharesTable" Kind="Table"/>
					</dbobject>
				</dbselectedtablesandviews>
				<FilterCollection>
					<FilterCollectionElement>
						<FilterPathPair>
							<PathInfo>
								<Path>
									<PathElement Name="DailySharePrices" Kind="DataSource"/>
									<PathElement Name="DailySharePrices" Kind="Database"/>
									<PathElement Name="SELECT_Prices_For_Duration" Kind="Select Statement"/>
								</Path>
							</PathInfo>
							<Filter/>
						</FilterPathPair>
					</FilterCollectionElement>
					<FilterCollectionElement>
						<FilterPathPair>
							<PathInfo>
								<Path>
									<PathElement Name="DailySharePrices" Kind="DataSource"/>
									<PathElement Name="DailySharePrices" Kind="Database"/>
									<PathElement Name="SELECT_Share_Sales_For_Duration" Kind="Select Statement"/>
								</Path>
							</PathInfo>
							<Filter/>
						</FilterPathPair>
					</FilterCollectionElement>
					<FilterCollectionElement>
						<FilterPathPair>
							<PathInfo>
								<Path>
									<PathElement Name="DailySharePrices" Kind="DataSource"/>
									<PathElement Name="DailySharePrices" Kind="Database"/>
									<PathElement Name="SharesTable" Kind="Table"/>
								</Path>
							</PathInfo>
							<Filter/>
						</FilterPathPair>
					</FilterCollectionElement>
				</FilterCollection>
			</dbschemasource>
		</schemasources>
	</schemasources>
	<modules/>
	<flags>
		<scripts/>
		<globalparts/>
		<designfragments/>
		<pagelayouts/>
		<xpath-functions/>
	</flags>
	<scripts>
		<script language="javascript"/>
	</scripts>
	<script-project>
		<Project version="2" app="AuthenticView"/>
	</script-project>
	<importedxslt/>
	<globalstyles/>
	<mainparts>
		<children>
			<globaltemplate subtype="main" match="/">
				<document-properties/>
				<children>
					<documentsection>
						<properties columncount="1" columngap="0.50in" headerfooterheight="fixed" pagemultiplepages="0" pagenumberingformat="1" pagenumberingstartat="auto" pagestart="next" paperheight="11in" papermarginbottom="0.79in" papermarginfooter="0.30in" papermarginheader="0.30in" papermarginleft="0.60in" papermarginright="0.60in" papermargintop="0.79in" paperwidth="8.50in"/>
					</documentsection>
					<paragraph paragraphtag="h2">
						<styles border-bottom="2px solid navy" color="navy"/>
						<children>
							<text fixtext="Example: Chart from  a non-XML Database"/>
						</children>
					</paragraph>
					<paragraph paragraphtag="p">
						<properties class="info"/>
						<children>
							<text fixtext="StyleVision allows you to use various databases as data source for your designs."/>
						</children>
					</paragraph>
					<paragraph paragraphtag="p">
						<properties class="explanation"/>
						<children>
							<text fixtext="When you drag an element that represents a DB table from the schema tree to the design, StyleVision allows you to generate data tables and charts in a variety of styles."/>
						</children>
					</paragraph>
					<paragraph paragraphtag="h2">
						<styles border-bottom="2px solid navy" color="navy"/>
						<children>
							<text fixtext="Chart of Nanonull Inc. Share Performance"/>
						</children>
					</paragraph>
					<paragraph paragraphtag="p">
						<properties class="info"/>
						<children>
							<text fixtext="The chart below is based on a SQL statement added to the Schema Tree to select and format a subset of the database table data:"/>
						</children>
					</paragraph>
					<template subtype="source" match="DB">
						<children>
							<template subtype="db" match="DB">
								<children>
									<template subtype="dbtable" match="SELECT_Share_Sales_For_Duration">
										<editorproperties elementstodisplay="5" elementstofetch="all"/>
										<children>
											<chart map-data-categories="1" multi-layer-chart="1">
												<styles height="400px" width="600px"/>
												<layer>
													<dataset/>
													<dataseries-xny-rows for-each="Row" x-value="@Expr1000" auto-x-value="0">
														<col y-value="@Open" y-name="&quot;Series 1&quot;"/>
														<col y-value="@High" y-name="&quot;Series 2&quot;"/>
														<col y-value="@Low" y-name="&quot;Series 3&quot;"/>
														<col y-value="@Close" y-name="&quot;Series 4&quot;"/>
													</dataseries-xny-rows>
													<wizard-data remove-empty-cat="1" remove-empty-ser="1">
														<wizard-data-categories/>
														<wizard-data-series/>
													</wizard-data>
													<chartsettings>
														<General SettingsVersion="2" ChartKind="CandleStick" BKColorGradientEnd="#cce8ff" PlotBKColorGradientEnd="#e8ffe9" Title="Nanonull Inc. Share Performance" ShowLegend="0">
															<TitleFont Size="5.%"/>
															<AxisLabelFont Size="3.5%"/>
														</General>
														<CandleStick FillHighClose="1" FillColorHighClose="#008000" FillHighOpenWithSeriesColor="0" FillColorHighOpen="#ff0000"/>
														<Colors Style="User" Colors="#000000" Colors1="#52aca0" Colors2="#0879b5" Colors3="#04b508" Colors4="#dc7708" Colors5="#dc143c" Colors6="#ffd700" Colors7="#4410a3" Colors8="#878369" Colors9="#b71b68" Colors10="#a25d2d" Colors11="#0028ff" Colors12="#bfbfbf" Colors13="#237518" Colors14="#d3c15d" Colors15="#8971d8"/>
														<XY>
															<XAxis>
																<ValueFont Size="2.5%"/>
															</XAxis>
															<YAxis AutoRange="0" RangeFrom="30.5" RangeTill="34.25" AxisLabel="Price per Share ($)" UseAutoTick="0" ManualTickInterval="0.5">
																<ValueFont Size="2.5%"/>
															</YAxis>
														</XY>
													</chartsettings>
													<chartsettings-xpath>
														<main-properties/>
														<color-properties/>
														<colorrange-properties/>
													</chartsettings-xpath>
												</layer>
												<layer>
													<dataset/>
													<dataseries-xny-rows>
														<col y-value="@Volume" y-name="&quot;Series 1&quot;"/>
													</dataseries-xny-rows>
													<wizard-data remove-empty-cat="1" remove-empty-ser="1">
														<wizard-data-categories/>
														<wizard-data-series/>
													</wizard-data>
													<chartsettings>
														<General SettingsVersion="2" BKColorGradientEnd="#cce8ff" PlotBKColorGradientEnd="#e8ffe9">
															<AxisLabelFont Size="3.5%"/>
														</General>
														<Colors Style="User" Colors="#52aca0" Colors1="#04b508" Colors2="#0879b5" Colors3="#dc7708" Colors4="#dc143c" Colors5="#ffd700" Colors6="#4410a3" Colors7="#878369" Colors8="#b71b68" Colors9="#a25d2d" Colors10="#0028ff" Colors11="#bfbfbf" Colors12="#237518" Colors13="#d3c15d" Colors14="#8971d8"/>
														<XY>
															<XAxis>
																<ValueFont Size="2.5%"/>
															</XAxis>
															<YAxis AutoRange="0" RangeFrom="15." RangeTill="90." AxisLabel="Volume (100,000s)" AxisPosition="RightOrTop">
																<ValueFont Size="2.5%"/>
															</YAxis>
														</XY>
													</chartsettings>
													<chartsettings-xpath>
														<main-properties/>
														<color-properties/>
														<colorrange-properties/>
													</chartsettings-xpath>
												</layer>
											</chart>
										</children>
										<variables/>
									</template>
								</children>
								<variables/>
							</template>
						</children>
						<variables/>
					</template>
					<newline/>
					<newline/>
					<paragraph paragraphtag="p">
						<properties class="info"/>
						<children>
							<text fixtext="The chart combines a Candlestick main chart for the Opening, High, Low, and Closing share prices with a Bar chart overlay for the daily share volume."/>
						</children>
					</paragraph>
					<newline break="page"/>
					<paragraph paragraphtag="p">
						<properties class="info"/>
						<children>
							<text fixtext="Here is the SQL query used to select data for the chart:"/>
						</children>
					</paragraph>
					<paragraph paragraphtag="p">
						<properties class="info"/>
						<styles font-family="Courier" font-size="smaller"/>
						<children>
							<text fixtext="SELECT Format ([Date], &quot;mm/dd&quot;),"/>
							<newline/>
							<text fixtext="       [Open],"/>
							<newline/>
							<text fixtext="       [High],"/>
							<newline/>
							<text fixtext="       [Low],"/>
							<newline/>
							<text fixtext="       [Close],"/>
							<newline/>
							<text fixtext="       [Volume] / 100000 AS Volume"/>
							<newline/>
							<text fixtext="FROM   [SharesTable]"/>
							<newline/>
							<text fixtext="WHERE  [Company] = &apos;Nanonull&apos;"/>
							<newline/>
							<text fixtext="AND ([Date] &gt;= DateValue (&quot;11/1/2010&quot;) AND [Date] &lt; DateValue (&quot;11/20/2010&quot;))"/>
							<newline/>
							<text fixtext="ORDER BY [Date] ASC;"/>
						</children>
					</paragraph>
					<paragraph paragraphtag="p">
						<properties class="info"/>
						<children>
							<text fixtext="One interesting enhancement to the query would be to use a calculation based on the Date () function to select the most recent three weeks of data preceding the current date from a table that is continuously updated with daily statistics."/>
						</children>
					</paragraph>
					<paragraph paragraphtag="p">
						<properties class="info"/>
						<children>
							<text fixtext="The same query can be used to generate a data table:"/>
						</children>
					</paragraph>
					<template subtype="source" match="DB">
						<children>
							<template subtype="db" match="DB">
								<children>
									<template subtype="dbtable" match="SELECT_Share_Sales_For_Duration">
										<editorproperties elementstodisplay="5"/>
										<children>
											<button>
												<action>
													<dbcontrol dbcontroltype="first"/>
												</action>
											</button>
											<button>
												<action>
													<dbcontrol dbcontroltype="prev"/>
												</action>
											</button>
											<button>
												<action>
													<dbcontrol dbcontroltype="goto"/>
												</action>
											</button>
											<button>
												<action>
													<dbcontrol/>
												</action>
											</button>
											<button>
												<action>
													<dbcontrol dbcontroltype="last"/>
												</action>
											</button>
											<tgrid>
												<properties border="1"/>
												<children>
													<tgridbody-cols>
														<children>
															<tgridcol/>
															<tgridcol/>
															<tgridcol/>
															<tgridcol/>
															<tgridcol/>
															<tgridcol/>
														</children>
													</tgridbody-cols>
													<tgridheader-rows>
														<children>
															<tgridrow>
																<styles font-family="Calibri"/>
																<children>
																	<tgridcell>
																		<children>
																			<text fixtext="Date"/>
																		</children>
																	</tgridcell>
																	<tgridcell>
																		<children>
																			<text fixtext="Open"/>
																		</children>
																	</tgridcell>
																	<tgridcell>
																		<children>
																			<text fixtext="High"/>
																		</children>
																	</tgridcell>
																	<tgridcell>
																		<children>
																			<text fixtext="Low"/>
																		</children>
																	</tgridcell>
																	<tgridcell>
																		<children>
																			<text fixtext="Close"/>
																		</children>
																	</tgridcell>
																	<tgridcell>
																		<children>
																			<text fixtext="Volume"/>
																		</children>
																	</tgridcell>
																</children>
															</tgridrow>
														</children>
													</tgridheader-rows>
													<tgridbody-rows>
														<children>
															<template subtype="dbrow" match="Row">
																<children>
																	<tgridrow>
																		<children>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="Expr1000">
																						<children>
																							<content>
																								<styles font-family="Calibri"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="Open">
																						<children>
																							<content>
																								<styles font-family="Calibri"/>
																								<format basic-type="xsd" datatype="double"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="High">
																						<children>
																							<content>
																								<styles font-family="Calibri"/>
																								<format basic-type="xsd" datatype="double"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="Low">
																						<children>
																							<content>
																								<styles font-family="Calibri"/>
																								<format basic-type="xsd" datatype="double"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="Close">
																						<children>
																							<content>
																								<styles font-family="Calibri"/>
																								<format basic-type="xsd" datatype="double"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="Volume">
																						<children>
																							<content>
																								<styles font-family="Calibri"/>
																								<format basic-type="xsd" datatype="double"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																		</children>
																	</tgridrow>
																</children>
																<variables/>
															</template>
														</children>
													</tgridbody-rows>
												</children>
											</tgrid>
										</children>
										<variables/>
									</template>
								</children>
								<variables/>
							</template>
						</children>
						<variables/>
					</template>
					<newline/>
					<newline break="page"/>
					<paragraph paragraphtag="h2">
						<styles border-bottom="2px solid navy" color="navy"/>
						<children>
							<text fixtext="Nanonull Inc. Share Data"/>
						</children>
					</paragraph>
					<paragraph paragraphtag="p">
						<properties class="info"/>
						<children>
							<text fixtext="The following table displays all the native data as it appears in the database table for your reference. In Authentic you can even edit this data and write it directly back into the database."/>
						</children>
					</paragraph>
					<template subtype="source" match="DB">
						<children>
							<tgrid>
								<properties border="1"/>
								<children>
									<tgridbody-cols>
										<children>
											<tgridcol>
												<styles width="2in"/>
											</tgridcol>
											<tgridcol/>
											<tgridcol/>
											<tgridcol/>
											<tgridcol/>
											<tgridcol/>
										</children>
									</tgridbody-cols>
									<tgridheader-rows>
										<children>
											<tgridrow>
												<children>
													<tgridcell>
														<children>
															<text fixtext="Date"/>
														</children>
													</tgridcell>
													<tgridcell>
														<children>
															<text fixtext="Volume"/>
														</children>
													</tgridcell>
													<tgridcell>
														<children>
															<text fixtext="High"/>
														</children>
													</tgridcell>
													<tgridcell>
														<children>
															<text fixtext="Low"/>
														</children>
													</tgridcell>
													<tgridcell>
														<children>
															<text fixtext="Open"/>
														</children>
													</tgridcell>
													<tgridcell>
														<children>
															<text fixtext="Close"/>
														</children>
													</tgridcell>
												</children>
											</tgridrow>
										</children>
									</tgridheader-rows>
									<tgridbody-rows>
										<children>
											<template subtype="db" match="DB">
												<children>
													<template subtype="dbtable" match="SharesTable">
														<children>
															<template subtype="dbrow" match="Row">
																<children>
																	<tgridrow>
																		<children>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="Date">
																						<children>
																							<content>
																								<format basic-type="xsd" datatype="dateTime"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="Volume">
																						<children>
																							<content>
																								<format basic-type="xsd" datatype="int"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="High">
																						<children>
																							<content>
																								<format basic-type="xsd" datatype="double"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="Low">
																						<children>
																							<content>
																								<format basic-type="xsd" datatype="double"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="Open">
																						<children>
																							<content>
																								<format basic-type="xsd" datatype="double"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																			<tgridcell>
																				<children>
																					<template subtype="dbfield" match="Close">
																						<children>
																							<content>
																								<format basic-type="xsd" datatype="double"/>
																							</content>
																						</children>
																						<variables/>
																					</template>
																				</children>
																			</tgridcell>
																		</children>
																	</tgridrow>
																</children>
																<variables/>
															</template>
														</children>
														<variables/>
													</template>
												</children>
												<variables/>
											</template>
										</children>
									</tgridbody-rows>
								</children>
							</tgrid>
						</children>
						<variables/>
					</template>
					<newline/>
				</children>
			</globaltemplate>
		</children>
	</mainparts>
	<globalparts/>
	<designfragments/>
	<xmltables/>
	<authentic-custom-toolbar-buttons/>
</structure>
