diff options
Diffstat (limited to 'source/text/swriter/01/04090006.xhp')
| -rw-r--r-- | source/text/swriter/01/04090006.xhp | 137 |
1 files changed, 137 insertions, 0 deletions
diff --git a/source/text/swriter/01/04090006.xhp b/source/text/swriter/01/04090006.xhp new file mode 100644 index 0000000000..0c2a368bf6 --- /dev/null +++ b/source/text/swriter/01/04090006.xhp @@ -0,0 +1,137 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + +<!-- +*********************************************************************** + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************ + --> + + +<meta> +<topic id="textswriter0104090006xml" indexer="include"> +<title id="tit" xml-lang="en-US">Database</title> +<filename>/text/swriter/01/04090006.xhp</filename> +</topic> +</meta> +<body> +<section id="datenbank"> +<bookmark xml-lang="en-US" branch="hid/SW_HID_FLD_DB" id="bm_id3151315" localize="false"/> +<paragraph role="heading" id="hd_id3153536" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/swriter/01/04090006.xhp" name="Database">Database</link></paragraph> +<paragraph role="paragraph" id="par_id3154471" xml-lang="en-US" l10n="U" oldref="2">You can insert fields from any database, for example, address fields, into your document.</paragraph> +</section> +<section id="howtoget"> +<embed href="text/swriter/00/00000404.xhp#felddatenbank"/> +</section> +<bookmark xml-lang="en-US" branch="hid/sw:ListBox:TP_FLD_DB:LB_DBTYPE" id="bm_id3154566" localize="false"/> +<paragraph role="paragraph" id="par_id090220080439090" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Lists the available field types. To add a field to your document, click a field type, click a field in the <emph>Select </emph>list, and then click <emph>Insert</emph>.</ahelp></paragraph> +<embed href="text/swriter/01/04090001.xhp#feldtyp"/> +<table id="tbl_id3155894"> +<tablerow> +<tablecell> +<paragraph role="tablehead" id="par_id3154196" xml-lang="en-US" l10n="U" oldref="3">Field type</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablehead" id="par_id3149484" xml-lang="en-US" l10n="U" oldref="4">Meaning</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3149096" xml-lang="en-US" l10n="U" oldref="5">Any Record</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3151257" xml-lang="en-US" l10n="U" oldref="6">Inserts the contents of the database field that you specify in the <emph>Record Number</emph> box as a mail merge field if the <link href="text/swriter/01/04090200.xhp" name="Condition"><emph>Condition</emph></link> that you enter is met. Only records selected by a multiple selection in the data source view are considered.</paragraph> +<paragraph role="tablecontent" id="par_id3147100" xml-lang="en-US" l10n="U" oldref="7">You can use this field to insert several records into a document. Simply insert the <emph>Any Record</emph> field in front of the form letter fields that use a certain record.</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3153632" xml-lang="en-US" l10n="U" oldref="8">Database Name</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3152776" xml-lang="en-US" l10n="U" oldref="9">Inserts the name of the database table selected in the <emph>Database selection </emph>box. The "Database Name" field is a global field, that is, if you insert a different database name in your document, the contents of all previously inserted "Database Name" fields are updated.</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3149167" xml-lang="en-US" l10n="U" oldref="15">Mail merge field</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3145779" xml-lang="en-US" l10n="U" oldref="16">Inserts the name of a database field as a placeholder, so that you can create a mail merge document. The field content is automatically inserted when you print the form letter.</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3151372" xml-lang="en-US" l10n="U" oldref="12">Next record</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3150114" xml-lang="en-US" l10n="U" oldref="13">Inserts the contents of the next mail merge field in your document, if the condition that you define is met. The records that you want to include must be selected in the data source view.</paragraph> +<paragraph role="tablecontent" id="par_id3155861" xml-lang="en-US" l10n="U" oldref="14">You can use the "Next record" field to insert the contents of consecutive records between the mail merge fields in a document.</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell> +<paragraph role="tablecontent" id="par_id3147412" xml-lang="en-US" l10n="U" oldref="10">Record number</paragraph> +</tablecell> +<tablecell> +<paragraph role="tablecontent" id="par_id3147495" xml-lang="en-US" l10n="U" oldref="11">Inserts the number of the selected database record.</paragraph> +</tablecell> +</tablerow> +</table> +<embed href="text/swriter/01/04090001.xhp#hinweis"/> +<bookmark xml-lang="en-US" branch="hid/SW_HID_DB_SELECTION_TLB" id="bm_id3145262" localize="false"/> +<paragraph role="heading" id="hd_id3149565" xml-lang="en-US" level="2" l10n="U" oldref="17">Database Selection</paragraph> +<paragraph role="paragraph" id="par_id3145268" xml-lang="en-US" l10n="U" oldref="18"><ahelp hid="HID_DB_SELECTION_TLB">Select the database table or the database query that you want the field to refer to.</ahelp> You can include fields from more than one database or query in a document.</paragraph> +<bookmark xml-lang="en-US" branch="hid/sw:Edit:TP_FLD_DB:ED_DBCONDITION" id="bm_id3150559" localize="false"/> +<paragraph role="paragraph" id="par_id0902200804391084" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">For fields linked to a condition, enter the criteria here.</ahelp></paragraph> +<embed href="text/swriter/01/04090003.xhp#bedingung"/> +<paragraph role="paragraph" id="par_id3147739" xml-lang="en-US" l10n="U" oldref="19">If you want, you can assign a condition that must be met before the contents of the "Any Record" and "Next Record" fields are inserted. The default condition is "True", that is, the condition is always true if you do not change the condition text.</paragraph> +<bookmark xml-lang="en-US" branch="hid/sw:Edit:TP_FLD_DB:ED_DBSETNUMBER" id="bm_id3149831" localize="false"/> +<paragraph role="heading" id="hd_id3146336" xml-lang="en-US" level="2" l10n="U" oldref="20">Record number</paragraph> +<paragraph role="paragraph" id="par_id3149836" xml-lang="en-US" l10n="U" oldref="21"><ahelp hid="SW:EDIT:TP_FLD_DB:ED_DBSETNUMBER">Enter the number of the record that you want to insert when the condition that you specify is met.</ahelp> The record number corresponds to the current selection in the data source view. For example, if you select the last 5 records in a database containing 10 records, the number of the first record will be 1, and not 6.</paragraph> +<paragraph role="note" id="par_id3153305" xml-lang="en-US" l10n="U" oldref="22">If you refer to fields in a different database (or in a different table or query within the same database), $[officename] determines the record number relative to the current selection.</paragraph> +<paragraph role="heading" id="hd_id3156109" xml-lang="en-US" level="2" l10n="U" oldref="23">Format</paragraph> +<paragraph role="paragraph" id="par_id3156122" xml-lang="en-US" l10n="CHG" oldref="24"><ahelp hid=".">Select the format of the field that you want to insert. This option is available for numerical, boolean, date and time fields.</ahelp><comment>see #i64135</comment></paragraph> +<bookmark xml-lang="en-US" branch="hid/sw:RadioButton:TP_FLD_DB:RB_DBOWNFORMAT" id="bm_id3150915" localize="false"/> +<paragraph role="heading" id="hd_id3150904" xml-lang="en-US" level="3" l10n="U" oldref="25">From database</paragraph> +<paragraph role="paragraph" id="par_id3150922" xml-lang="en-US" l10n="U" oldref="26"><ahelp hid="SW:RADIOBUTTON:TP_FLD_DB:RB_DBOWNFORMAT">Uses the format defined in the selected database.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/sw:PushButton:TP_FLD_DB:PB_ADDDB" id="bm_id5024262" localize="false"/> +<paragraph role="heading" id="par_idN1076E" xml-lang="en-US" level="3" l10n="NEW">Browse</paragraph> +<paragraph role="paragraph" id="par_idN10772" xml-lang="en-US" l10n="NEW"><ahelp hid="878711313">Opens a file open dialog where you can select a database file (*.odb). The selected file is added to the Databases Selection list.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/sw:RadioButton:TP_FLD_DB:RB_DBFORMAT" id="bm_id3154326" localize="false"/> +<paragraph role="heading" id="hd_id3155084" xml-lang="en-US" level="3" l10n="U" oldref="27">User defined</paragraph> +<paragraph role="paragraph" id="par_id3154333" xml-lang="en-US" l10n="U" oldref="28"><ahelp hid="SW:RADIOBUTTON:TP_FLD_DB:RB_DBFORMAT">Applies the format that you select in the <emph>List of user-defined formats</emph>.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/sw:ListBox:TP_FLD_DB:LB_DBNUMFORMAT" id="bm_id3150084" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/sw:ListBox:TP_FLD_DB:LB_DBFORMAT" id="bm_id3150087" localize="false"/> +<paragraph role="heading" id="hd_id3146948" xml-lang="en-US" level="3" l10n="U" oldref="29">List of user-defined formats</paragraph> +<paragraph role="paragraph" id="par_id3150093" xml-lang="en-US" l10n="U" oldref="30"><ahelp hid="SW:LISTBOX:TP_FLD_DB:LB_DBFORMAT">Lists the available user-defined formats.</ahelp></paragraph> +<bookmark xml-lang="en-US" branch="hid/SW_HID_PRINT_AS_MERGE" id="bm_id1835383" localize="false"/> +<paragraph role="heading" id="par_idN107FF" xml-lang="en-US" level="2" l10n="NEW">Printing a form letter</paragraph> +<paragraph role="paragraph" id="par_idN10803" xml-lang="en-US" l10n="NEW"><ahelp hid=".">When you print a document that contains database fields, a dialog asks you if you want to print a form letter. If you answer Yes, the <link href="text/swriter/01/01150000.xhp">Mail Merge</link> dialog opens where you can select the database records to print.</ahelp></paragraph> +<paragraph role="heading" id="par_idN10812" xml-lang="en-US" level="3" l10n="NEW">Do not show warning again</paragraph> +<paragraph role="paragraph" id="par_idN10816" xml-lang="en-US" l10n="CHG"><ahelp hid=".">Suppresses this dialog from now on. There is no easy way to get it back!</ahelp></paragraph> +</body> +</helpdocument> |