source/text/shared/02/14010000.xhp | 41 ++++++++++++---------------
source/text/shared/02/14020000.xhp | 55 +++++++++++++++----------------------
source/text/shared/02/14020100.xhp | 38 ++++++++++++-------------
source/text/shared/02/14020200.xhp | 41 +++++++++++----------------
source/text/shared/02/14030000.xhp | 43 ++++++++++++----------------
source/text/shared/02/14040000.xhp | 55 +++++++++++++++----------------------
source/text/shared/02/14050000.xhp | 41 ++++++++++++---------------
source/text/shared/02/14060000.xhp | 55 +++++++++++++++----------------------
source/text/shared/02/14070000.xhp | 41 ++++++++++++---------------
9 files changed, 177 insertions(+), 233 deletions(-)
New commits:
commit de2a4c1173cb242b0dce04a52ce390b14ea8a413
Author: Sophia Schröder <sophia.schroe...@libreoffice.org>
Date: Sat Jun 9 10:57:04 2018 +0200
Cleanups and improvements
in /shared/02/14*.xhp files
Change-Id: I6da71717abcab59b9ad2556273a70db34200ec44
Reviewed-on: https://gerrit.libreoffice.org/55503
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/shared/02/14010000.xhp
b/source/text/shared/02/14010000.xhp
index 10f814d07..aa0f0f124 100644
--- a/source/text/shared/02/14010000.xhp
+++ b/source/text/shared/02/14010000.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -18,16 +17,15 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-<helpdocument version="1.0">
+
<meta>
-<topic id="textshared0214010000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Run</title>
-<filename>/text/shared/02/14010000.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
+ <topic id="textshared0214010000xml" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Run</title>
+ <filename>/text/shared/02/14010000.xhp</filename>
+ </topic>
+ <history>
+ <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+ </history>
</meta>
<body>
<section id="abfrage">
@@ -35,22 +33,19 @@
<paragraph role="heading" id="hd_id3156183" xml-lang="en-US" level="1"><link
href="text/shared/02/14010000.xhp" name="Run">Run Query</link></paragraph>
<paragraph role="paragraph" id="par_id3109850" xml-lang="en-US"><ahelp
hid=".uno:SbaExecuteSql">Runs the SQL query and displays the query
result.</ahelp> The <emph>Run Query</emph> function does not save the
query.</paragraph>
</section>
-<paragraph role="paragraph" id="par_id3149893" xml-lang="en-US">The<emph> Run
Query </emph>function allows you to check the query. When you save the query,
it is stored in the <emph>Query</emph> tab page.</paragraph>
+<paragraph role="paragraph" id="par_id3149893" xml-lang="en-US">The <emph>Run
Query</emph> function allows you to check the query. When you save the query,
it is stored in the <emph>Query</emph> tab page.</paragraph>
<paragraph role="tip" id="par_idN10621" xml-lang="en-US">Choose <emph>View -
Preview</emph> to run the query from the menu bar of a query design
window.<comment>UFI: see dba-features "Querydesign: Close preview has
moved"</comment></paragraph>
<section id="syabfrage">
<table id="tbl_id3147226">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3155941" xml-lang="en-US">
-<image id="img_id3153311" src="cmd/sc_sbaexecutesql.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3153311" xml-lang="en-US">Icon</alt>
- </image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3153684" xml-lang="en-US">Run
Query</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph role="paragraph" id="par_id3155941" xml-lang="en-US"><image
id="img_id3153311" src="cmd/sc_sbaexecutesql.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3153311"
xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph role="paragraph" id="par_id3153684" xml-lang="en-US">Run
Query</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-
</section>
</body>
</helpdocument>
diff --git a/source/text/shared/02/14020000.xhp
b/source/text/shared/02/14020000.xhp
index 000b1d471..0f2dea6f8 100644
--- a/source/text/shared/02/14020000.xhp
+++ b/source/text/shared/02/14020000.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -19,39 +18,31 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-<helpdocument version="1.0">
<meta>
-<topic id="textshared0214020000xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Clear query</title>
-<filename>/text/shared/02/14020000.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
+ <topic id="textshared0214020000xml" indexer="include" status="PUBLISH">
+ <title xml-lang="en-US" id="tit">Clear query</title>
+ <filename>/text/shared/02/14020000.xhp</filename>
+ </topic>
+ <history>
+ <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+ </history>
</meta>
<body>
-
-
- <section id="abfrageleeren">
- <bookmark branch="hid/.uno:DBClearQuery" xml-lang="en-US" id="bm_id3147000"
localize="false"/><paragraph id="hd_id3146946" role="heading" level="1"
xml-lang="en-US"><link href="text/shared/02/14020000.xhp" name="Clear
query">Clear query</link></paragraph>
- <paragraph role="paragraph" id="par_id3155934" xml-lang="en-US"><ahelp
hid=".uno:DBClearQuery" visibility="visible">Clears the query and removes all
tables from the design window.</ahelp></paragraph>
- </section>
- <section id="syabfrageleeren">
- <table id="tbl_id3154232">
-
-
-
- <tablerow>
- <tablecell>
+<section id="abfrageleeren">
+<bookmark branch="hid/.uno:DBClearQuery" xml-lang="en-US" id="bm_id3147000"
localize="false"/><paragraph id="hd_id3146946" role="heading" level="1"
xml-lang="en-US"><link href="text/shared/02/14020000.xhp" name="Clear
query">Clear query</link></paragraph>
+<paragraph role="paragraph" id="par_id3155934" xml-lang="en-US"><ahelp
hid=".uno:DBClearQuery" visibility="visible">Clears the query and removes all
tables from the design window.</ahelp></paragraph>
+</section>
+<section id="syabfrageleeren">
+<table id="tbl_id3154232">
+ <tablerow>
+ <tablecell>
<paragraph role="paragraph" id="par_id3154422" xml-lang="en-US"><image
src="cmd/sc_dbclearquery.png" id="img_id3149205"><alt xml-lang="en-US"
id="alt_id3149205">Icon</alt></image></paragraph>
- </tablecell>
- <tablecell>
+ </tablecell>
+ <tablecell>
<paragraph role="paragraph" id="par_id3150789" xml-lang="en-US">Clear
query</paragraph>
- </tablecell>
- </tablerow>
-
- </table>
- </section>
-
- </body>
+ </tablecell>
+ </tablerow>
+</table>
+</section>
+</body>
</helpdocument>
diff --git a/source/text/shared/02/14020100.xhp
b/source/text/shared/02/14020100.xhp
index f33395cb6..4ea302a62 100644
--- a/source/text/shared/02/14020100.xhp
+++ b/source/text/shared/02/14020100.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,39 +17,38 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
+
<meta>
- <topic id="textshared0214020100xml" indexer="include" status="PUBLISH">
- <title xml-lang="en-US" id="tit">Add Tables</title>
- <filename>/text/shared/02/14020100.xhp</filename>
- </topic>
- </meta>
- <body>
+ <topic id="textshared0214020100xml" indexer="include" status="PUBLISH">
+ <title xml-lang="en-US" id="tit">Add Tables</title>
+ <filename>/text/shared/02/14020100.xhp</filename>
+ </topic>
+</meta>
+<body>
<bookmark xml-lang="en-US" branch="index"
id="bm_id3154788"><bookmark_value>tables in databases; adding to
queries</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:AddTable" id="bm_id8385907"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:AddTable" id="bm_id3143284"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/tablesjoindialog/tablelist"
id="bm_id3159224" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3154788" role="heading" level="1">Add
Tables</paragraph>
- <paragraph xml-lang="en-US" id="par_id3152821"
role="paragraph"><variable id="tabellehinzufuegentext"><ahelp
hid="dbaccess/ui/tablesjoindialog/tablelist" visibility="hidden">Specifies the
tables to be inserted into the design window.</ahelp> In the<emph> Add Tables
</emph>dialog, select the tables you need for your current task.
+<paragraph xml-lang="en-US" id="par_id3152821" role="paragraph"><variable
id="tabellehinzufuegentext"><ahelp hid="dbaccess/ui/tablesjoindialog/tablelist"
visibility="hidden">Specifies the tables to be inserted into the design
window.</ahelp> In the <emph>Add Tables</emph> dialog, select the tables you
need for your current task.
</variable> When creating a query or a new table presentation, select the
corresponding table to which the query or table presentation should refer. When
working with relational databases, select the tables between which you want to
build relationships.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149760" role="paragraph">The
inserted tables appear in a separate window in the query design or relational
windows, along with a list of the fields contained in the table. You can
determine the size and order of this window.</paragraph>
- <section id="howtoget">
- <embed href="text/shared/00/00000450.xhp#tabellehinzu"/>
- </section>
- <paragraph xml-lang="en-US" id="hd_id3154927" role="heading"
level="2">Table</paragraph>
+<paragraph xml-lang="en-US" id="par_id3149760" role="paragraph">The inserted
tables appear in a separate window in the query design or relational windows,
along with a list of the fields contained in the table. You can determine the
size and order of this window.</paragraph>
+<section id="howtoget">
+ <embed href="text/shared/00/00000450.xhp#tabellehinzu"/>
+</section>
+<paragraph xml-lang="en-US" id="hd_id3154927" role="heading"
level="2">Table</paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/tablesjoindialog/tables"
id="bm_id0305200912070094" localize="false"/>
<paragraph xml-lang="en-US" id="par_id030520091208059" role="paragraph"><ahelp
hid="." visibility="hidden">Shows only tables.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/tablesjoindialog/queries"
id="bm_id0305200912074475" localize="false"/>
<paragraph xml-lang="en-US" id="par_id0305200912080616"
role="paragraph"><ahelp hid="." visibility="hidden">Shows only
queries.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150713" role="heading"
level="3">Table name</paragraph>
- <paragraph xml-lang="en-US" id="par_id3156042" role="paragraph"><ahelp
hid="dbaccess/ui/tablesjoindialog/tablelist">Lists the available
tables.</ahelp> To insert a table, select one from the list and click
<emph>Add</emph>. You can also double-click the table name, and a window will
be displayed containing the table fields at the top of the query design or the
relational window.</paragraph>
+<paragraph xml-lang="en-US" id="hd_id3150713" role="heading" level="3">Table
name</paragraph>
+<paragraph xml-lang="en-US" id="par_id3156042" role="paragraph"><ahelp
hid="dbaccess/ui/tablesjoindialog/tablelist">Lists the available
tables.</ahelp> To insert a table, select one from the list and click
<emph>Add</emph>. You can also double-click the table name, and a window will
be displayed containing the table fields at the top of the query design or the
relational window.</paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/tablesjoindialog/add"
id="bm_id3155941" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3151226" role="heading"
level="2">Add</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153683" role="paragraph"><ahelp
hid="dbaccess/ui/tablesjoindialog/add">Inserts the currently selected
table.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="par_id3153683" role="paragraph"><ahelp
hid="dbaccess/ui/tablesjoindialog/add">Inserts the currently selected
table.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/tablesjoindialog/close"
id="bm_id3153311" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3153527" role="heading"
level="2">Close</paragraph>
- <paragraph xml-lang="en-US" id="par_id3156410" role="paragraph"><ahelp
hid="dbaccess/ui/tablesjoindialog/close">Closes the <emph>Add Tables</emph>
dialog.</ahelp></paragraph>
- </body>
+<paragraph xml-lang="en-US" id="par_id3156410" role="paragraph"><ahelp
hid="dbaccess/ui/tablesjoindialog/close">Closes the <emph>Add Tables</emph>
dialog.</ahelp></paragraph>
+</body>
</helpdocument>
diff --git a/source/text/shared/02/14020200.xhp
b/source/text/shared/02/14020200.xhp
index 1d8745e91..26afc52d2 100644
--- a/source/text/shared/02/14020200.xhp
+++ b/source/text/shared/02/14020200.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -19,38 +18,32 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-
-<helpdocument version="1.0">
<meta>
-<topic id="textshared0214020200xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Switch Design View On / Off</title>
-<filename>/text/shared/02/14020200.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
+ <topic id="textshared0214020200xml" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Switch Design View On/Off</title>
+ <filename>/text/shared/02/14020200.xhp</filename>
+ </topic>
+ <history>
+ <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+ </history>
</meta>
<body>
<section id="designansicht">
<bookmark xml-lang="en-US" branch="hid/.uno:DBChangeDesignMode"
id="bm_id3151262" localize="false"/>
-<paragraph role="heading" id="hd_id3159411" xml-lang="en-US" level="1"><link
href="text/shared/02/14020200.xhp" name="Switch Design View On / Off">Switch
Design View On / Off</link></paragraph>
+<paragraph role="heading" id="hd_id3159411" xml-lang="en-US" level="1"><link
href="text/shared/02/14020200.xhp" name="Switch Design View On / Off">Switch
Design View On/Off</link></paragraph>
<paragraph role="paragraph" id="par_id3149495" xml-lang="en-US"><ahelp
hid=".uno:DBChangeDesignMode">Displays the design view or the SQL view of the
query.</ahelp></paragraph>
</section>
<section id="sydesignansicht">
<table id="tbl_id3155150">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3149140" xml-lang="en-US">
-<image id="img_id3152918" src="cmd/sc_dbchangedesignmode.png"
width="0.222inch" height="0.222inch"><alt id="alt_id3152918"
xml-lang="en-US">Icon</alt>
- </image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3147399" xml-lang="en-US">Switch Design
View On / Off</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph role="paragraph" id="par_id3149140" xml-lang="en-US"><image
id="img_id3152918" src="cmd/sc_dbchangedesignmode.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3152918"
xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph role="paragraph" id="par_id3147399" xml-lang="en-US">Switch
Design View On/Off</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-
</section>
</body>
</helpdocument>
diff --git a/source/text/shared/02/14030000.xhp
b/source/text/shared/02/14030000.xhp
index b0537ca39..22f5539e7 100644
--- a/source/text/shared/02/14030000.xhp
+++ b/source/text/shared/02/14030000.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -18,40 +17,36 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-<helpdocument version="1.0">
+
<meta>
-<topic id="textshared0214030000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Run SQL command directly</title>
-<filename>/text/shared/02/14030000.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
+ <topic id="textshared0214030000xml" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Run SQL command directly</title>
+ <filename>/text/shared/02/14030000.xhp</filename>
+ </topic>
+ <history>
+ <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+ </history>
</meta>
<body>
<section id="native">
<paragraph role="paragraph" id="par_id3149748" xml-lang="en-US"
localize="false"/>
<bookmark xml-lang="en-US" branch="hid/.uno:SbaNativeSql" id="bm_id3143284"
localize="false"/>
<paragraph role="heading" id="hd_id3151100" xml-lang="en-US" level="1"><link
href="text/shared/02/14030000.xhp" name="Run SQL command directly">Run SQL
command directly</link></paragraph>
-<paragraph role="paragraph" id="par_id3155364" xml-lang="en-US"><ahelp
hid=".uno:SbaNativeSql">In Native SQL mode you can enter SQL commands that are
not interpreted by $[officename], but are instead passed directly to the data
source.</ahelp> If you do not display these changes in the design view, you
cannot change back to the design view.</paragraph>
+<paragraph role="paragraph" id="par_id3155364" xml-lang="en-US"><ahelp
hid=".uno:SbaNativeSql">In <emph>Native SQL</emph> mode you can enter SQL
commands that are not interpreted by $[officename], but are instead passed
directly to the data source.</ahelp> If you do not display these changes in the
design view, you cannot change back to the design view.</paragraph>
</section>
<paragraph role="paragraph" id="par_id3149999" xml-lang="en-US">For native
SQL, the SQL string is forwarded directly to the connected database system
without a previous evaluation by $[officename]. For example, if you access a
database through an ODBC interface, the SQL string is passed to the ODBC driver
and processed by it.</paragraph>
<section id="synative">
<table id="tbl_id3150710">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3145136" xml-lang="en-US">
-<image id="img_id3147226" src="cmd/sc_sbanativesql.png"><alt
id="alt_id3147226" xml-lang="en-US">Icon</alt>
- </image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3155893" xml-lang="en-US">Run SQL
command directly</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph role="paragraph" id="par_id3145136" xml-lang="en-US"><image
id="img_id3147226" src="cmd/sc_sbanativesql.png"><alt id="alt_id3147226"
xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph role="paragraph" id="par_id3155893" xml-lang="en-US">Run SQL
command directly</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-
</section>
-<paragraph role="paragraph" id="par_id3155535" xml-lang="en-US">Click the icon
again to return to normal mode, in which the changes in the <link
href="text/shared/explorer/database/02010100.xhp" name="New Query Design">New
Query Design</link> are synchronized with the permitted changes through
SQL.</paragraph>
+<paragraph role="paragraph" id="par_id3155535" xml-lang="en-US">Click the icon
again to return to normal mode, in which the changes in the <link
href="text/shared/explorer/database/02010100.xhp" name="New Query
Design"><emph>New Query Design</emph></link> are synchronized with the
permitted changes through SQL.</paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/02/14040000.xhp
b/source/text/shared/02/14040000.xhp
index 50bd93c79..cf762f0e9 100644
--- a/source/text/shared/02/14040000.xhp
+++ b/source/text/shared/02/14040000.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -19,39 +18,31 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-<helpdocument version="1.0">
<meta>
-<topic id="textshared0214040000xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Functions</title>
-<filename>/text/shared/02/14040000.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
+ <topic id="textshared0214040000xml" indexer="include" status="PUBLISH">
+ <title xml-lang="en-US" id="tit">Functions</title>
+ <filename>/text/shared/02/14040000.xhp</filename>
+ </topic>
+ <history>
+ <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+ </history>
</meta>
<body>
-
-
- <section id="funktionen">
- <bookmark branch="hid/.uno:DBViewFunctions" xml-lang="en-US"
id="bm_id3154840" localize="false"/><paragraph id="hd_id3153514" role="heading"
level="1" xml-lang="en-US"><link href="text/shared/02/14040000.xhp"
name="Functions">Functions</link></paragraph>
- <paragraph role="paragraph" id="par_id3159224" xml-lang="en-US"><ahelp
visibility="visible" hid=".uno:DBViewFunctions">Displays the
"Function" row in the lower part of the design view of the <link
href="text/shared/explorer/database/02010100.xhp" name="Query Design">Query
Design</link> window.</ahelp></paragraph>
- </section>
- <section id="syfunktionen">
- <table id="tbl_id3149119">
-
-
-
- <tablerow>
- <tablecell>
+<section id="funktionen">
+<bookmark branch="hid/.uno:DBViewFunctions" xml-lang="en-US" id="bm_id3154840"
localize="false"/><paragraph id="hd_id3153514" role="heading" level="1"
xml-lang="en-US"><link href="text/shared/02/14040000.xhp"
name="Functions">Functions</link></paragraph>
+<paragraph role="paragraph" id="par_id3159224" xml-lang="en-US"><ahelp
visibility="visible" hid=".uno:DBViewFunctions">Displays the
<emph>Function</emph> row in the lower part of the design view of the <link
href="text/shared/explorer/database/02010100.xhp" name="Query
Design"><emph>Query Design</emph></link> window.</ahelp></paragraph>
+</section>
+<section id="syfunktionen">
+<table id="tbl_id3149119">
+ <tablerow>
+ <tablecell>
<paragraph role="paragraph" id="par_id3149205" xml-lang="en-US"><image
src="cmd/sc_dbviewfunctions.png" id="img_id3154399"><alt xml-lang="en-US"
id="alt_id3154399">Icon</alt></image></paragraph>
- </tablecell>
- <tablecell>
+ </tablecell>
+ <tablecell>
<paragraph role="paragraph" id="par_id3145669"
xml-lang="en-US">Functions</paragraph>
- </tablecell>
- </tablerow>
-
- </table>
- </section>
-
- </body>
+ </tablecell>
+ </tablerow>
+</table>
+</section>
+</body>
</helpdocument>
diff --git a/source/text/shared/02/14050000.xhp
b/source/text/shared/02/14050000.xhp
index cc028b8e8..28ad1129a 100644
--- a/source/text/shared/02/14050000.xhp
+++ b/source/text/shared/02/14050000.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -18,37 +17,33 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-<helpdocument version="1.0">
+
<meta>
-<topic id="textshared0214050000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Table Name</title>
-<filename>/text/shared/02/14050000.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
+ <topic id="textshared0214050000xml" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Table Name</title>
+ <filename>/text/shared/02/14050000.xhp</filename>
+ </topic>
+ <history>
+ <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+ </history>
</meta>
<body>
<section id="tabellenname">
<bookmark xml-lang="en-US" branch="hid/.uno:DBViewTableNames"
id="bm_id2447279" localize="false"/>
<paragraph role="heading" id="hd_id3149991" xml-lang="en-US" level="1"><link
href="text/shared/02/14050000.xhp" name="Table Name">Table
Name</link></paragraph>
-<paragraph role="paragraph" id="par_id3154232" xml-lang="en-US"><ahelp
hid=".">Displays the "Table" row in the lower part of the <link
href="text/shared/explorer/database/02010100.xhp" name="Query Design">Query
Design</link>.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3154232" xml-lang="en-US"><ahelp
hid=".">Displays the <emph>Table</emph> row in the lower part of the <link
href="text/shared/explorer/database/02010100.xhp" name="Query
Design"><emph>Query Design</emph></link>.</ahelp></paragraph>
</section>
<section id="sytabellenname">
<table id="tbl_id3147102">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3154116" xml-lang="en-US">
-<image id="img_id3149760" src="cmd/sc_dbviewtablenames.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3149760" xml-lang="en-US">Icon</alt>
- </image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3157896" xml-lang="en-US">Table
Name</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph role="paragraph" id="par_id3154116" xml-lang="en-US"><image
id="img_id3149760" src="cmd/sc_dbviewtablenames.png" width="0.222inch"
height="0.222inch"><alt id="alt_id3149760"
xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph role="paragraph" id="par_id3157896" xml-lang="en-US">Table
Name</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-
</section>
</body>
</helpdocument>
diff --git a/source/text/shared/02/14060000.xhp
b/source/text/shared/02/14060000.xhp
index 47cd08825..c0a0b3291 100644
--- a/source/text/shared/02/14060000.xhp
+++ b/source/text/shared/02/14060000.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -19,39 +18,31 @@
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-<helpdocument version="1.0">
<meta>
-<topic id="textshared0214060000xml" indexer="include" status="PUBLISH">
-<title xml-lang="en-US" id="tit">Alias</title>
-<filename>/text/shared/02/14060000.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
+ <topic id="textshared0214060000xml" indexer="include" status="PUBLISH">
+ <title xml-lang="en-US" id="tit">Alias</title>
+ <filename>/text/shared/02/14060000.xhp</filename>
+ </topic>
+ <history>
+ <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+ </history>
</meta>
<body>
-
-
- <section id="aliasname">
- <bookmark branch="hid/.uno:DBViewAliases" xml-lang="en-US" id="bm_id3151299"
localize="false"/><paragraph id="hd_id3150758" role="heading" level="1"
xml-lang="en-US"><link href="text/shared/02/14060000.xhp"
name="Alias">Alias</link></paragraph>
- <paragraph role="paragraph" id="par_id3148731" xml-lang="en-US"><ahelp
visibility="visible" hid=".uno:DBViewAliases">Displays the "Alias"
row in the lower part of the <link
href="text/shared/explorer/database/02010100.xhp" name="Query Design">Query
Design</link>.</ahelp></paragraph>
- </section>
- <section id="syaliasname">
- <table id="tbl_id3149716">
-
-
-
- <tablerow>
- <tablecell>
+<section id="aliasname">
+<bookmark branch="hid/.uno:DBViewAliases" xml-lang="en-US" id="bm_id3151299"
localize="false"/><paragraph id="hd_id3150758" role="heading" level="1"
xml-lang="en-US"><link href="text/shared/02/14060000.xhp"
name="Alias">Alias</link></paragraph>
+<paragraph role="paragraph" id="par_id3148731" xml-lang="en-US"><ahelp
visibility="visible" hid=".uno:DBViewAliases">Displays the <emph>Alias</emph>
row in the lower part of the <link
href="text/shared/explorer/database/02010100.xhp" name="Query
Design"><emph>Query Design</emph></link>.</ahelp></paragraph>
+</section>
+<section id="syaliasname">
+<table id="tbl_id3149716">
+ <tablerow>
+ <tablecell>
<paragraph role="paragraph" id="par_id3150808" xml-lang="en-US"><image
src="cmd/sc_dbviewaliases.png" id="img_id3151315"><alt xml-lang="en-US"
id="alt_id3151315">Icon</alt></image></paragraph>
- </tablecell>
- <tablecell>
+ </tablecell>
+ <tablecell>
<paragraph role="paragraph" id="par_id3151234"
xml-lang="en-US">Alias</paragraph>
- </tablecell>
- </tablerow>
-
- </table>
- </section>
-
- </body>
+ </tablecell>
+ </tablerow>
+</table>
+</section>
+</body>
</helpdocument>
diff --git a/source/text/shared/02/14070000.xhp
b/source/text/shared/02/14070000.xhp
index ce334a07b..4441c1e05 100644
--- a/source/text/shared/02/14070000.xhp
+++ b/source/text/shared/02/14070000.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
+<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
@@ -18,16 +17,15 @@
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
-
-<helpdocument version="1.0">
+
<meta>
-<topic id="textshared0214070000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Distinct Values</title>
-<filename>/text/shared/02/14070000.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-</history>
+ <topic id="textshared0214070000xml" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Distinct Values</title>
+ <filename>/text/shared/02/14070000.xhp</filename>
+ </topic>
+ <history>
+ <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+ </history>
</meta>
<body>
<section id="eindeutige">
@@ -36,22 +34,19 @@
</bookmark>
<bookmark xml-lang="en-US" branch="hid/.uno:DBDistinctValues"
id="bm_id3147588" localize="false"/>
<paragraph role="heading" id="hd_id3149991" xml-lang="en-US" level="1"><link
href="text/shared/02/14070000.xhp" name="Distinct Values">Distinct
Values</link></paragraph>
-<paragraph role="paragraph" id="par_id3154894" xml-lang="en-US"><ahelp
hid=".uno:DBDistinctValues">Expands the created select statement of the <link
href="text/shared/explorer/database/02010100.xhp" name="SQL Query">SQL
Query</link> in the current column by the parameter DISTINCT.</ahelp> The
consequence is that identical values occurring multiple times are listed only
once.</paragraph>
+<paragraph role="paragraph" id="par_id3154894" xml-lang="en-US"><ahelp
hid=".uno:DBDistinctValues">Expands the created select statement of the <link
href="text/shared/explorer/database/02010100.xhp" name="SQL Query"><emph>SQL
Query</emph></link> in the current column by the parameter
<emph>DISTINCT</emph>.</ahelp> The consequence is that identical values
occurring multiple times are listed only once.</paragraph>
</section>
<section id="syeindeutige">
<table id="tbl_id3150935">
-<tablerow>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3149511" xml-lang="en-US">
-<image id="img_id3156302" src="cmd/sc_dbdistinctvalues.png" width="5.64mm"
height="5.64mm"><alt id="alt_id3156302" xml-lang="en-US">Icon</alt>
- </image></paragraph>
-</tablecell>
-<tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3147226" xml-lang="en-US">Distinct
Values</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell colspan="" rowspan="">
+ <paragraph role="paragraph" id="par_id3149511" xml-lang="en-US"><image
id="img_id3156302" src="cmd/sc_dbdistinctvalues.png" width="5.64mm"
height="5.64mm"><alt id="alt_id3156302"
xml-lang="en-US">Icon</alt></image></paragraph>
+ </tablecell>
+ <tablecell colspan="" rowspan="">
+ <paragraph role="paragraph" id="par_id3147226" xml-lang="en-US">Distinct
Values</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-
</section>
</body>
</helpdocument>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
