helpcontent2/source/text/shared/00/00000450.xhp

   1 <?xml version="1.0" encoding="UTF-8"?>
   2
   3
   4
   5 <!--
   6  ***********************************************************************
   7  *
   8  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   9  *
  10  * Copyright 2008 by Sun Microsystems, Inc.
  11  *
  12  * OpenOffice.org - a multi-platform office productivity suite
  13  *
  14  * $RCSfile: 00000450.xhp,v $
  15  * $Revision: 1.12 $
  16  *
  17  * This file is part of OpenOffice.org.
  18  *
  19  * OpenOffice.org is free software: you can redistribute it and/or modify
  20  * it under the terms of the GNU Lesser General Public License version 3
  21  * only, as published by the Free Software Foundation.
  22  *
  23  * OpenOffice.org is distributed in the hope that it will be useful,
  24  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  25  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  26  * GNU Lesser General Public License version 3 for more details
  27  * (a copy is included in the LICENSE file that accompanied this code).
  28  *
  29  * You should have received a copy of the GNU Lesser General Public License
  30  * version 3 along with OpenOffice.org.  If not, see
  31  * <http://www.openoffice.org/license.html>
  32  * for a copy of the LGPLv3 License.
  33  *
  34  ************************************************************************
  35  -->
  36
  37
  38                 <helpdocument version="1.0">
  39 <meta>
  40 <topic id="textshared0000000450xml" indexer="exclude" status="PUBLISH">
  41 <title id="tit" xml-lang="en-US">Database</title>
  42 <filename>/text/shared/00/00000450.xhp</filename>
  43 </topic>
  44 </meta>
  45 <body>
  46 <paragraph role="heading" id="hd_id3154689" xml-lang="en-US" level="1" l10n="U" oldref="1">Database</paragraph>
  47 <paragraph role="paragraph" id="par_id3152876" xml-lang="en-US" l10n="CHG" oldref="7"><variable id="DBTab">In a database file window, choose <emph>Tools - Table Filter</emph>
  48 </variable></paragraph>
  49 <paragraph role="paragraph" id="par_id3153244" xml-lang="en-US" l10n="CHG" oldref="57"><variable id="DBAbfragen"><emph>View - Database Objects - Queries</emph>
  50 </variable></paragraph>
  51 <paragraph role="paragraph" id="par_id3147294" xml-lang="en-US" l10n="CHG" oldref="4"><variable id="Typ">In a database file window, choose <emph>Edit - Database - Properties - Advanced Settings</emph> tab
  52 </variable></paragraph>
  53 <paragraph role="paragraph" id="par_id3159411" xml-lang="en-US" l10n="CHG" oldref="5"><variable id="Datenquelle">In a database file window of type ODBC or Address book, choose Edit - Database - Connection Type
  54 </variable></paragraph>
  55 <paragraph role="paragraph" id="par_id3149119" xml-lang="en-US" l10n="U" oldref="6"><variable id="Verzeichnis">Path selection button in various Wizards / <emph>Edit</emph> Buttons for some entries in <emph>Tools - Options - $[officename] - Paths</emph>
  56 </variable></paragraph>
  57 <paragraph role="paragraph" id="par_id3154497" xml-lang="en-US" l10n="CHG" oldref="8"><variable id="ODBC">In a database file window of type ODBC, choose Edit - Database - Connection Type
  58 </variable><comment>see #i56356</comment></paragraph>
  59 <paragraph role="paragraph" id="par_id3149355" xml-lang="en-US" l10n="CHG" oldref="61"><variable id="ldap">In a database file window of type Address book - LDAP, choose Edit - Database - Properties
  60 </variable></paragraph>
  61 <paragraph role="paragraph" id="par_id3157896" xml-lang="en-US" l10n="CHG" oldref="9"><variable id="JDBC">In a database file window of type JDBC, choose <emph>Edit - Database - Properties</emph>
  62 </variable></paragraph>
  63 <paragraph role="paragraph" id="par_id3148548" xml-lang="en-US" l10n="CHG" oldref="81"><variable id="mysql">In a database file window of type MySQL, choose <emph>Edit - Database - Properties</emph>
  64 </variable></paragraph>
  65 <paragraph role="paragraph" id="par_id3149346" xml-lang="en-US" l10n="CHG" oldref="10"><variable id="dBase">In a database file window of type dBASE, choose <emph>Edit - Database - Properties</emph>
  66 </variable></paragraph>
  67 <paragraph role="paragraph" id="par_id3147043" xml-lang="en-US" l10n="CHG" oldref="11"><variable id="dBasein">In a database file window of type dBASE, choose <emph>Edit - Database - Properties</emph>, click <emph>Indexes</emph>
  68 </variable></paragraph>
  69 <paragraph role="paragraph" id="par_id3154317" xml-lang="en-US" l10n="CHG" oldref="12"><variable id="Text">In a database file window of type Text, choose <emph>Edit - Database - Properties</emph>
  70 </variable></paragraph>
  71 <paragraph role="paragraph" id="par_id3150774" xml-lang="en-US" l10n="CHG" oldref="20"><variable id="ADO">In a database file window of type MS ADO, choose <emph>Edit - Database - Properties</emph>
  72 </variable></paragraph>
  73 <paragraph role="paragraph" id="par_id3151110" xml-lang="en-US" l10n="CHG" oldref="21"><variable id="SQLStatement">In a database file window, choose <emph>Tools - SQL</emph>
  74 </variable></paragraph>
  75 <paragraph role="paragraph" id="par_id3147209" xml-lang="en-US" l10n="CHG" oldref="22"><variable id="Abfragen">In a database file window, click the <emph>Queries</emph> icon
  76 </variable></paragraph>
  77 <paragraph role="paragraph" id="par_id3153880" xml-lang="en-US" l10n="CHG" oldref="62"><variable id="Tabellen">In a database file window, click the <emph>Tables</emph> icon
  78 </variable></paragraph>
  79 <section id="tabellehinzu">
  80 <paragraph role="paragraph" id="par_id3153760" xml-lang="en-US" l10n="CHG" oldref="64"><variable id="tabellenentwurf">In a database file window, click the Tables icon. Choose Insert -<emph> Table Design</emph> or <emph>Edit - Edit</emph>
  81 </variable></paragraph>
  82 </section>
  83 <paragraph role="paragraph" id="par_id3156329" xml-lang="en-US" l10n="U" oldref="65"><variable id="indexentwurf">In a database file window, click the Tables icon. Choose <emph>Insert - Table Design</emph> or <emph>Edit - Edit</emph>
  84 </variable><comment>UFI: was: "... , then Tools - Index Design or Index Design button"
  85  (don't know where that is now)</comment></paragraph>
  86 <paragraph role="paragraph" id="par_id3154047" xml-lang="en-US" l10n="CHG" oldref="23"><variable id="AbfrageNeu">In a database file window, choose <emph>Insert - Query (Design view)</emph>
  87 </variable></paragraph>
  88 <paragraph role="paragraph" id="par_id3149579" xml-lang="en-US" l10n="CHG" oldref="24"><variable id="entwab">In a database file window, click the <emph>Queries</emph> icon, then choose <emph>Edit - Edit</emph>
  89 </variable></paragraph>
  90 <paragraph role="paragraph" id="par_id3149902" xml-lang="en-US" l10n="CHG" oldref="25"><variable id="FehlendesElement">In a database file window, click the <emph>Queries</emph> icon, then choose <emph>Edit - Edit</emph>. When referenced fields no longer exist, you see this dialog
  91 </variable></paragraph>
  92 <paragraph role="paragraph" id="par_id3159166" xml-lang="en-US" l10n="U" oldref="26"><variable id="Joins">Open query design and choose <emph>Insert - New Relation</emph>, or double-click on a connection line between two tables.
  93 </variable></paragraph>
  94 <section id="sytabelle">
  95 <table id="tbl_id3156192">
  96 <tablerow>
  97 <tablecell colspan="" rowspan="">
  98 <paragraph role="paragraph" id="par_id3151245" xml-lang="en-US" l10n="E">
  99 <image id="img_id3153063" src="res/commandimagelist/sc_addtable.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153063" xml-lang="en-US">Icon</alt>
 100         </image></paragraph>
 101 </tablecell>
 102 <tablecell colspan="" rowspan="">
 103 <paragraph role="paragraph" id="par_id3153896" xml-lang="en-US" l10n="U" oldref="41">Insert Tables</paragraph>
 104 </tablecell>
 105 </tablerow>
 106 </table>
 107 </section>
 108 <section id="SyRelationen">
 109 <table id="tbl_id3152360">
 110 <tablerow>
 111 <tablecell colspan="" rowspan="">
 112 <paragraph role="paragraph" id="par_id3149457" xml-lang="en-US" l10n="E">
 113 <image id="img_id3147282" src="res/commandimagelist/sc_dbaddrelation.png" width="0.222inch" height="0.222inch"><alt id="alt_id3147282" xml-lang="en-US">Icon</alt>
 114         </image></paragraph>
 115 </tablecell>
 116 <tablecell colspan="" rowspan="">
 117 <paragraph role="paragraph" id="par_id3159085" xml-lang="en-US" l10n="U" oldref="43">New Relation</paragraph>
 118 </tablecell>
 119 </tablerow>
 120 </table>
 121 </section>
 122 <section id="datensuchen">
 123 <paragraph role="paragraph" id="par_id3150414" xml-lang="en-US" l10n="U" oldref="47">
 124 <emph>Find Record</emph> icon on the Table Data bar and Form Design bar</paragraph>
 125 <section id="sydatensuchen">
 126 <table id="tbl_id3148797">
 127 <tablerow>
 128 <tablecell colspan="" rowspan="">
 129 <paragraph role="paragraph" id="par_id3157962" xml-lang="en-US" l10n="E">
 130 <image id="img_id3145419" src="res/commandimagelist/sc_recsearch.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145419" xml-lang="en-US">Icon</alt>
 131         </image></paragraph>
 132 </tablecell>
 133 <tablecell colspan="" rowspan="">
 134 <paragraph role="paragraph" id="par_id3157322" xml-lang="en-US" l10n="U" oldref="48">Find Record</paragraph>
 135 </tablecell>
 136 </tablerow>
 137 </table>
 138 </section>
 139 </section>
 140 <section id="sortieren">
 141 <paragraph role="paragraph" id="par_id3150870" xml-lang="en-US" l10n="U" oldref="49">
 142 <emph>Sort Order</emph> icon on the Table Data bar and Form Design bar</paragraph>
 143 <section id="sysortieren">
 144 <table id="tbl_id3153353">
 145 <tablerow>
 146 <tablecell colspan="" rowspan="">
 147 <paragraph role="paragraph" id="par_id3150393" xml-lang="en-US" l10n="E">
 148 <image id="img_id3145606" src="res/sc10714.png" width="0.222inch" height="0.222inch"><alt id="alt_id3145606" xml-lang="en-US">Icon</alt>
 149         </image></paragraph>
 150 </tablecell>
 151 <tablecell colspan="" rowspan="">
 152 <paragraph role="paragraph" id="par_id3145745" xml-lang="en-US" l10n="U" oldref="50">Sort Order</paragraph>
 153 </tablecell>
 154 </tablerow>
 155 </table>
 156 </section>
 157 </section>
 158 <paragraph role="paragraph" id="par_id3145171" xml-lang="en-US" l10n="CHG" oldref="55"><variable id="allgemein">In a database file window, choose <emph>Edit - Database - Properties</emph>
 159 </variable></paragraph>
 160 <paragraph role="paragraph" id="par_id3159252" xml-lang="en-US" l10n="CHG" oldref="63"><variable id="tabellecopy">Drag and drop a table or a query into the table part of another database file window
 161 </variable></paragraph>
 162 <paragraph role="paragraph" id="par_id3148560" xml-lang="en-US" l10n="CHG" oldref="66"><variable id="formularneu">In a database file window, choose<emph> Insert - Form</emph>
 163 </variable></paragraph>
 164 <paragraph role="paragraph" id="par_id3155430" xml-lang="en-US" l10n="CHG" oldref="67"><variable id="benutzereinstellungen">In a database file window, choose <emph>Edit - Database - Properties</emph>
 165 </variable></paragraph>
 166 <paragraph role="paragraph" id="par_id3147441" xml-lang="en-US" l10n="CHG" oldref="69"><variable id="relationen">In a database file window, choose <emph>Tools - Relationships</emph>
 167 </variable></paragraph>
 168 </body>
 169 </helpdocument>