1
2
3
4
5
6
7
8
9
10
11
12
13
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01109535"><META NAME="lcid" CONTENT="1033"><title>About secondary data sources</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>About secondary data sources</h1><div class="ofvbanav"><span class="ofvbanavreuse" id="seealso" onclick="toggleList()" onkeypress="toggleList()"></span><span class="ofvbanavreuse" id="specifics" onclick="toggleList()" onkeypress="toggleList()"></span></div><p>Microsoft Office InfoPath 2003 Service Pack 1 adds the ability to connect multiple <a href="#" class="glossary" onclick="AppendPopup(this,'xddatasource')" onkeypress="AppendPopup(this,'xddatasource')">data sources</a> to a form simultaneously. Using multiple data sources in your forms allows you to build complex functionality such as lookup lists or offline data stores.</p><h2>Main and secondary data sources</h2><p>The <i>main data source</i> corresponds to the groups and fields containing the data that underlies the form and is saved as the form file.</p><p>A <i>secondary data source</i> is used to store data from additional data sources. Whenever a new data connection is created for retrieving data<nbsp />— for example, by using the <b class="ui">Add</b> button of the <b class="ui">Data Connections</b> dialog box<nbsp />— the retrieved data is not stored in the main data source but in a secondary data source. The secondary data source receives the data from any data connection used for querying, whether it is an XML document, a database, a Web service, or a SharePoint library or list. </p><p> The <b class="ui">Data Source</b> task pane displays the structure (groups and fields) of each data source, both main and secondary, and is used for binding groups or fields in the data source to controls in the form. When a user fills out the form, the controls display the data from the data source and allow it to be updated during editing. </p><h2>New features for working with secondary data sources</h2><p>The following sections describe the changes made to working with secondary data sources in InfoPath Service Pack 1.</p><p><a href="#" class="DropDown" onclick="Outline2()" onkeypress="Outline2()"><img border="0" src="blueup.gif" alt="Show">The Data Connections dialog box</a></p><div id="ExpCol" class="collapsed" border="0"><p>The <b class="ui">Secondary Data Sources</b> dialog box, which was accessed from the <b class="ui">Tools</b> menu, has been replaced by a new <b class="ui">Data Connections</b> dialog box that provides a single place to manage all data connections. The data connections are of the following types:<ul><li>The main connection for a form, which is created by using the <b class="ui">New from Data Connection</b> command in the <b class="ui">Design a Form</b> task pane.</li><li>Data connections used to retrieve data, which are associated with secondary data sources.</li><li>Data connections used to submit data.</li></ul></p>
<p>The <b class="ui">Data Connections</b> dialog box allows you to add data connections for submitting or retrieving data, modifying existing data connections, and removing existing data connections. It also displays a summary of the current settings for each data connection.</p>
</div><p><a href="#" class="DropDown" onclick="Outline2()" onkeypress="Outline2()"><img border="0" src="blueup.gif" alt="Show">Data Source task pane</a></p><div id="ExpCol" class="collapsed" border="0"><p>The <b class="ui">Data Source</b> task pane in InfoPath Service Pack 1 provides a drop-down list of available data sources, so that both the main data source and secondary data sources can be displayed. Groups and fields from secondary data sources can be dragged onto the form, as can groups and fields from the main data source, to create controls for displaying or editing their data. </p></div><p><a href="#" class="DropDown" onclick="Outline2()" onkeypress="Outline2()"><img border="0" src="blueup.gif" alt="Show">Fields and groups </a></p><div id="ExpCol" class="collapsed" border="0"><p>A drop-down list similar to one in the <b class="ui">Data Source</b> task pane is available in other situations in which the user can choose a group or field. For example, it is now possible to choose a field or group from a secondary data source when doing the following:<ul><li>Changing the binding on a control in the view.</li><li>Setting conditions for data validation.</li><li>Setting conditions for conditional formatting.</li><li>Setting the data to be submitted as parameters to a Web service.</li><li>Inserting formulas.</li><li>Setting conditions in rules.</li></ul></p><p><p><b>Note</b> Data in secondary data sources is not saved with the form, so making secondary data sources editable in the form makes sense only in certain scenarios. You can display high-level secondary data source content simply by dragging a high-level secondary data source node from the <b class="ui">Data Source</b> task pane into the view and choosing <b class="ui">Section with Controls</b>. Text boxes can be made read-only, if needed. </p></p></div><p><a href="#" class="DropDown" onclick="Outline2()" onkeypress="Outline2()"><img border="0" src="blueup.gif" alt="Show">Controls available for binding to secondary data sources</a></p><div id="ExpCol" class="collapsed" border="0"><p>The following controls can be bound to secondary data sources with no restrictions on their behavior:<ul><li>Date Picker</li><li>Drop-Down List Box</li><li>Ink Picture</li><li>List Box</li></ul></p><p>The following controls cannot be bound to secondary data sources:<ul><li>Custom Controls</li><li>File Attachment</li><li>Master/Detail</li><li>Optional Section</li></ul></p><p>The following controls can be bound to secondary data sources, but with some restrictions on their behavior:</p><table><tr><th>Control</th><th>Behavior</th></tr><tr></tr><tr><td>Check Box</td><td>All features enabled, except that the value of the <b class="bterm">Default state</b> property of the control is <b class="bterm">Cleared</b> and cannot be changed</td></tr><tr><td>Choice Group</td><td>No insertion, deletion, or replacement of groups</td></tr><tr><td>Choice Section</td><td>No insertion, deletion, or replacement of sections</td></tr><tr><td>Linked Picture</td><td>No browsing</td></tr><tr><td>List (Bulleted, Plain Numbered)</td><td>Can edit text, but cannot add items</td></tr><tr><td>Option Button</td><td>All features enabled, except that the <b class="bterm">This button is selected by default</b> property check box is cleared and disabled</td></tr><tr><td>Picture</td><td>No browsing</td></tr><tr><td>Repeating Choice Group</td><td>No insertion, deletion, or replacement of groups</td></tr><tr><td>Repeating Recursive Section</td><td>No insertion, deletion, or replacement of sections</td></tr><tr><td>Repeating Section</td><td>No insertion, deletion, or replacement of sections</td></tr><tr><td>Repeating Table</td><td>No insertion, deletion, or replacement of rows</td></tr><tr><td>Rich Text Box</td><td>Read only</td></tr><tr><td>Section</td><td>No insertion, deletion, or replacement of sections</td></tr><tr><td>Text Box</td><td>The <b class="ui">Enable spelling checker</b> and <b class="ui">Enable AutoComplete</b> check boxes cannot be turned off</td></tr></table></div><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/inconAboutSecondaryDataSources_HV01109535_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>
|
