AllLangHelp_sdatabase.mk | 6 ++++++
AllLangHelp_shared.mk | 6 ------
source/text/sdatabase/11000002.xhp | 11 ++++-------
source/text/sdatabase/11020000.xhp | 31 +++++++++++++------------------
source/text/sdatabase/11030000.xhp | 20 ++++++++++----------
source/text/sdatabase/11030100.xhp | 25 ++++++++++---------------
source/text/sdatabase/11080000.xhp | 21 ++++++++-------------
source/text/sdatabase/11090000.xhp | 13 ++++---------
source/text/shared/02/12010000.xhp | 2 +-
9 files changed, 56 insertions(+), 79 deletions(-)
New commits:
commit f8bb58500148b126c2730977d566e7fa315439b0
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sun May 2 08:49:46 2021 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon May 3 15:58:58 2021 +0200
Refactor more database help files
Change-Id: I1384c2d3d0090ce15fc5088bff4bfdb07fa7cdbf
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114995
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_sdatabase.mk b/AllLangHelp_sdatabase.mk
index a1899d7fd..b2723e0c4 100644
--- a/AllLangHelp_sdatabase.mk
+++ b/AllLangHelp_sdatabase.mk
@@ -39,6 +39,12 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sdatabase,\
helpcontent2/source/text/sdatabase/05040100 \
helpcontent2/source/text/sdatabase/05040200 \
helpcontent2/source/text/sdatabase/toolbars \
+ helpcontent2/source/text/sdatabase/11000002 \
+ helpcontent2/source/text/sdatabase/11020000 \
+ helpcontent2/source/text/sdatabase/11030000 \
+ helpcontent2/source/text/sdatabase/11030100 \
+ helpcontent2/source/text/sdatabase/11080000 \
+ helpcontent2/source/text/sdatabase/11090000 \
))
# vim: set noet sw=4 ts=4:
diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk
index 5ffdc9d92..65feeac78 100644
--- a/AllLangHelp_shared.mk
+++ b/AllLangHelp_shared.mk
@@ -861,12 +861,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\
))
$(eval $(call gb_AllLangHelp_add_helpfiles,shared,\
- helpcontent2/source/text/shared/explorer/database/11000002 \
- helpcontent2/source/text/shared/explorer/database/11020000 \
- helpcontent2/source/text/shared/explorer/database/11030000 \
- helpcontent2/source/text/shared/explorer/database/11030100 \
- helpcontent2/source/text/shared/explorer/database/11080000 \
- helpcontent2/source/text/shared/explorer/database/11090000 \
helpcontent2/source/text/shared/explorer/database/dabaadvprop \
helpcontent2/source/text/shared/explorer/database/dabaadvpropdat \
helpcontent2/source/text/shared/explorer/database/dabaadvpropgen \
diff --git a/source/text/shared/explorer/database/11000002.xhp
b/source/text/sdatabase/11000002.xhp
similarity index 84%
rename from source/text/shared/explorer/database/11000002.xhp
rename to source/text/sdatabase/11000002.xhp
index c5e91dd6c..43107a4a2 100644
--- a/source/text/shared/explorer/database/11000002.xhp
+++ b/source/text/sdatabase/11000002.xhp
@@ -1,6 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -18,12 +16,11 @@
* 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="textsharedexplorerdatabase11000002xml" indexer="include"
status="PUBLISH">
<title id="tit" xml-lang="en-US">Data sources in $[officename]</title>
-<filename>/text/shared/explorer/database/11000002.xhp</filename>
+<filename>/text/sdatabase/05040200.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
@@ -32,13 +29,13 @@
<body>
<bookmark xml-lang="en-US" branch="index"
id="bm_id3155449"><bookmark_value>databases;drag and drop
(Base)</bookmark_value>
</bookmark><comment>mw added "(Base)"</comment>
-<paragraph role="heading" id="hd_id3151299" xml-lang="en-US" level="1"><link
href="text/shared/explorer/database/11000002.xhp" name="Data sources in
$[officename]">Data sources in $[officename]</link></paragraph>
+<h1 id="hd_id3151299"><link href="text/sdatabase/05040200.xhp" name="Data
sources in $[officename]">Data sources in $[officename]</link></h1>
<section id="address_book">
-<paragraph role="heading" id="hd_id3150616" xml-lang="en-US"
level="2">Selecting the Address Book</paragraph>
+<h2 id="hd_id3150616">Selecting the Address Book</h2>
<embed href="text/shared/guide/data_addressbook.xhp#address_book"/>
<paragraph role="paragraph" id="par_id3153049" xml-lang="en-US">To select the
address book that you want to use, choose <link
href="text/shared/01/01110101.xhp" name="Tools - Address Book
Source"><emph>Tools - Address Book Source</emph></link>.</paragraph>
</section>
-<paragraph role="heading" id="hd_id3147275" xml-lang="en-US" level="2">Opening
a Data Source</paragraph>
+<h2 id="hd_id3147275">Opening a Data Source</h2>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_id3154143" xml-lang="en-US">To open the
data source view, press <switchinline select="sys"><caseinline
select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Shift+F4</keycode>
in a text, spreadsheet or form document.</paragraph>
diff --git a/source/text/shared/explorer/database/11020000.xhp
b/source/text/sdatabase/11020000.xhp
similarity index 76%
rename from source/text/shared/explorer/database/11020000.xhp
rename to source/text/sdatabase/11020000.xhp
index 642783c67..8e1f9484b 100644
--- a/source/text/shared/explorer/database/11020000.xhp
+++ b/source/text/sdatabase/11020000.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,55 +16,53 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabase11020000xml" indexer="exclude"
status="PUBLISH">
<title id="tit" xml-lang="en-US">ODBC</title>
-<filename>/text/shared/explorer/database/11020000.xhp</filename>
+<filename>/text/sdatabase/11020000.xhp</filename>
</topic>
</meta>
<body>
<section id="odbc">
-<paragraph role="heading" id="hd_id3149031" xml-lang="en-US" level="1"><link
href="text/shared/explorer/database/11020000.xhp"
name="ODBC">ODBC</link><comment>still some Help IDs in this file. Else it can
be removed</comment></paragraph>
+<h1 id="hd_id3149031"><link href="text/sdatabase/11020000.xhp"
name="ODBC">ODBC</link><comment>still some Help IDs in this file. Else it can
be removed</comment></h1>
<paragraph role="paragraph" id="par_id3150499" xml-lang="en-US"><ahelp
hid=".">Specifies the settings for <link
href="text/shared/00/00000005.xhp#odbc" name="ODBC">ODBC</link> databases. This
includes your user access data, driver settings, and font
definitions.</ahelp></paragraph>
</section>
<section id="username">
-<paragraph role="heading" id="hd_id3148642" xml-lang="en-US" level="2">User
Name</paragraph>
+<h2 id="hd_id3148642">User Name</h2>
<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US"><ahelp
hid=".">Type the user name for accessing the database.</ahelp></paragraph>
</section>
<section id="password">
-<paragraph role="heading" id="hd_id3153665" xml-lang="en-US"
level="2">Password required</paragraph>
+<h2 id="hd_id3153665">Password required</h2>
<paragraph role="paragraph" id="par_id3145119" xml-lang="en-US"><ahelp
hid=".">Prevents an unauthorized user from accessing the database. You only
need to enter the password once per session.</ahelp></paragraph>
</section>
<section id="driver settings">
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/odbcpage/options"
id="bm_id3148473" localize="false"/><paragraph role="heading" id="hd_id3153087"
xml-lang="en-US" level="2">Driver Settings</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/odbcpage/options"
id="bm_id3148473" localize="false"/><h2 id="hd_id3153087">Driver Settings</h2>
<paragraph role="paragraph" id="par_id3143271" xml-lang="en-US"><ahelp
hid="dbaccess/ui/odbcpage/options">Use this text field to enter additional
optional driver settings if this is necessary.</ahelp></paragraph>
</section>
<section id="character_set">
-<!-- removed HID HID_DSADMIN_CHARSET_ODBC --><paragraph role="heading"
id="hd_id3152472" xml-lang="en-US" level="2">Character Set</paragraph>
+<!-- removed HID HID_DSADMIN_CHARSET_ODBC --><h2 id="hd_id3152472">Character
Set</h2>
<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US"><ahelp
hid="HID_DSADMIN_CHARSET_ODBC">Select the code conversion that you want to use
to view the database in $[officename]. This does not affect the
database.</ahelp> Choose "System" to use the default character set of your
operating system. Text and dBASE databases are restricted to character sets
with a fixed-size character length, where all characters are encoded with the
same number of bytes.</paragraph>
</section>
<section id="retrieve">
-<paragraph role="heading" id="hd_id3149669" xml-lang="en-US"
level="2">General</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/generatedvaluespage/autoretrieve" id="bm_id3161657"
localize="false"/><paragraph role="heading" id="hd_id3147265" xml-lang="en-US"
level="3">Retrieve generated values</paragraph>
+<h2 id="hd_id3149669">General</h2>
+<bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/generatedvaluespage/autoretrieve" id="bm_id3161657"
localize="false"/><h3 id="hd_id3147265">Retrieve generated values</h3>
<paragraph role="paragraph" id="par_id3151054" xml-lang="en-US"><ahelp
hid="dbaccess/ui/generatedvaluespage/autoretrieve">Enables $[officename]
support of auto-incremented data fields for the current ODBC or JDBC data
source.</ahelp> Select this check box if the database does not support the
auto-increment feature in its SDBCX layer. In general, the auto-increment is
selected for the primary key field.</paragraph>
-<bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/generatedvaluespage/statement" id="bm_id3150792"
localize="false"/><paragraph role="heading" id="hd_id3150400" xml-lang="en-US"
level="3">Auto-increment statement</paragraph>
+<bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/generatedvaluespage/statement" id="bm_id3150792"
localize="false"/><h3 id="hd_id3150400">Auto-increment statement</h3>
<paragraph role="paragraph" id="par_id3154366" xml-lang="en-US"><ahelp
hid="dbaccess/ui/generatedvaluespage/statement">Enter the SQL command specifier
that instructs the data source to auto-increment a specified Integer data
field.</ahelp> For example, a typical SQL statement to create a data field is:
</paragraph>
<paragraph role="paragraph" id="par_id3159149" xml-lang="en-US">CREATE TABLE
"table1" ("id" INTEGER)</paragraph>
<paragraph role="paragraph" id="par_id3147084" xml-lang="en-US">To
auto-increment the "id" data field in a MySQL database, change the statement
to:</paragraph>
<paragraph role="paragraph" id="par_id3154909" xml-lang="en-US">CREATE TABLE
"table1" ("id" INTEGER AUTO_INCREMENT)</paragraph>
<paragraph role="paragraph" id="par_id3152933" xml-lang="en-US">In other
words, enter AUTO_INCREMENT into <emph>Auto-increment statement</emph>
box.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/generatedvaluespage/query"
id="bm_id3153195" localize="false"/><paragraph role="heading" id="hd_id3149765"
xml-lang="en-US" level="3">Query of generated values</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/generatedvaluespage/query"
id="bm_id3153195" localize="false"/><h3 id="hd_id3149765">Query of generated
values</h3>
<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US"><ahelp
hid="dbaccess/ui/generatedvaluespage/query">Enter an SQL statement that returns
the last auto-incremented value for the primary key data field.</ahelp> For
example:</paragraph>
<paragraph role="paragraph" id="par_id3150769" xml-lang="en-US">SELECT
LAST_INSERT_D();</paragraph>
</section>
<section id="sql92">
-<bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/specialsettingspage/usesql92" id="bm_id3147289"
localize="false"/><paragraph role="heading" id="hd_id3157892" xml-lang="en-US"
level="3">Use SQL92 naming constraints</paragraph>
+<bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/specialsettingspage/usesql92" id="bm_id3147289"
localize="false"/><h3 id="hd_id3157892">Use SQL92 naming constraints</h3>
<paragraph role="paragraph" id="par_id3153368" xml-lang="en-US"><ahelp
hid="dbaccess/ui/specialsettingspage/usesql92">Only allows names that use
characters that conform to the SQL92 naming constraints in the data source. All
other characters are rejected.</ahelp> Each name must begin with a lower or
upper case letter, or an underline ( _ ). The remaining characters can be ASCII
letters, underlines, and numbers.</paragraph>
</section>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_USECATALOG"
id="bm_id3146148" localize="false"/><paragraph role="heading" id="hd_id3154011"
xml-lang="en-US" level="3">Use Catalog for file-based databases</paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_USECATALOG"
id="bm_id3146148" localize="false"/><h3 id="hd_id3154011">Use Catalog for
file-based databases</h3>
<paragraph role="paragraph" id="par_id3148618" xml-lang="en-US"><ahelp
hid="HID_DSADMIN_USECATALOG">Uses the current data source of the Catalog. This
is useful when the ODBC data source is a database server. If the ODBC data
source is a dBASE driver, leave this check box clear.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/explorer/database/11030000.xhp
b/source/text/sdatabase/11030000.xhp
similarity index 80%
rename from source/text/shared/explorer/database/11030000.xhp
rename to source/text/sdatabase/11030000.xhp
index 5b2fc6bc6..ab8555a4c 100644
--- a/source/text/shared/explorer/database/11030000.xhp
+++ b/source/text/sdatabase/11030000.xhp
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
+
<!--
* This file is part of the LibreOffice project.
*
@@ -18,17 +18,17 @@
* 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="textsharedexplorerdatabase11030000xml" indexer="exclude">
<title id="tit" xml-lang="en-US">dBASE</title>
-<filename>/text/shared/explorer/database/11030000.xhp</filename>
+<filename>/text/sdatabase/11030000.xhp</filename>
</topic>
</meta>
<body>
<section id="dbase"><comment>ufi: removed remaining two index
entries</comment><comment>mw added "(Base)" to all 4 entries and transferred 2
entries to shared/explorer/database/dabawiz02dbase.xhp</comment>
-<paragraph role="heading" id="hd_id3153539" xml-lang="en-US" level="1"><link
href="text/shared/explorer/database/11030000.xhp"
name="dBase">dBASE</link><comment>still two Help IDs in this file. Else file
can be removed</comment></paragraph>
+<h1 id="hd_id3153539"><link href="text/sdatabase/11030000.xhp"
name="dBase">dBASE</link><comment>still two Help IDs in this file. Else file
can be removed</comment></h1>
<paragraph role="paragraph" id="par_id3147088" xml-lang="en-US"><ahelp
hid=".">Specify the settings for a dBASE database.</ahelp></paragraph>
</section>
<section id="howtoget">
@@ -36,17 +36,17 @@
</section>
<paragraph role="paragraph" id="par_id3151110" xml-lang="en-US">To be able to
define relations between tables, use JDBC or ODBC from within
$[officename].</paragraph>
<bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/dbasepage/showDelRowsCheckbutton" id="bm_id3154142"
localize="false"/>
-<paragraph role="heading" id="hd_id3149233" xml-lang="en-US" level="2">Display
inactive records</paragraph>
+<h2 id="hd_id3149233">Display inactive records</h2>
<paragraph role="paragraph" id="par_id3153823" xml-lang="en-US"><ahelp
hid="dbaccess/ui/dbasepage/showDelRowsCheckbutton">Displays all the records in
a file, including those marked as deleted. If you select this check box, you
cannot delete records.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3156023" xml-lang="en-US">In dBASE
format, deleted records remain in the file. </paragraph>
<paragraph role="paragraph" id="par_id3151384" xml-lang="en-US">To view any
changes that you make to the database, close the connection to the database,
and then reconnect the database.</paragraph>
<paragraph role="paragraph" id="par_id6051820" xml-lang="en-US"
localize="false"><comment>UFI: deleted note about case sensitivity. Should be
not other than for all other files.</comment></paragraph>
<!-- removed HID HID_DSADMIN_CHARSET_DBASE -->
<paragraph role="paragraph" id="par_id0904200811094971"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Select the code conversion
that you want to use to view the database in $[officename]. This does not
affect the database.</ahelp></paragraph>
-<embed href="text/shared/explorer/database/11020000.xhp#character_set"/>
-<embed href="text/shared/explorer/database/11020000.xhp#sql92"/>
+<embed href="text/sdatabase/11020000.xhp#character_set"/>
+<embed href="text/sdatabase/11020000.xhp#sql92"/>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbasepage/indiciesButton"
id="bm_id3151056" localize="false"/>
-<paragraph role="heading" id="hd_id3149047" xml-lang="en-US"
level="2">Indexes</paragraph>
-<paragraph role="paragraph" id="par_id3161656" xml-lang="en-US"><ahelp
hid="dbaccess/ui/dbasepage/indiciesButton">Opens the <link
href="text/shared/explorer/database/11030100.xhp"
name="Indexes"><emph>Indexes</emph></link> dialog, where you can organize the
table indexes in the current dBASE database.</ahelp></paragraph>
+<h2 id="hd_id3149047">Indexes</h2>
+<paragraph role="paragraph" id="par_id3161656" xml-lang="en-US"><ahelp
hid="dbaccess/ui/dbasepage/indiciesButton">Opens the <link
href="text/sdatabase/11030100.xhp" name="Indexes"><emph>Indexes</emph></link>
dialog, where you can organize the table indexes in the current dBASE
database.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/explorer/database/11030100.xhp
b/source/text/sdatabase/11030100.xhp
similarity index 74%
rename from source/text/shared/explorer/database/11030100.xhp
rename to source/text/sdatabase/11030100.xhp
index 11e6378fd..9eb5a8a73 100644
--- a/source/text/shared/explorer/database/11030100.xhp
+++ b/source/text/sdatabase/11030100.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,35 +16,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">
+<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabase11030100xml" indexer="include"
status="PUBLISH">
<title id="tit" xml-lang="en-US">Indexes</title>
-<filename>/text/shared/explorer/database/11030100.xhp</filename>
+<filename>/text/sdatabase/11030100.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/dbaseindexdialog/DBaseIndexDialog" id="bm_id3146959"
localize="false"/>
-<paragraph role="heading" id="hd_id3148983" xml-lang="en-US" level="1"><link
href="text/shared/explorer/database/11030100.xhp"
name="Indexes">Indexes</link></paragraph>
+<h1 id="hd_id3148983"><link href="text/sdatabase/11030100.xhp"
name="Indexes">Indexes</link></h1>
<paragraph role="paragraph" id="par_id3150247" xml-lang="en-US"><ahelp
hid=".">Lets you organize dBASE database indexes.</ahelp> An index allows you
to access a database quickly, provided that you query the data in the selection
that was defined through the index. When you design a table, you can define the
indexes on the <emph>Indexes </emph>tab page.</paragraph>
<section id="howtoget">
<embed href="text/shared/00/00000450.xhp#dBasein"/>
</section>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/table"
id="bm_id3146958" localize="false"/><paragraph role="heading" id="hd_id3155339"
xml-lang="en-US" level="2">Table</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/table"
id="bm_id3146958" localize="false"/><h2 id="hd_id3155339">Table</h2>
<paragraph role="paragraph" id="par_id3152551" xml-lang="en-US"><ahelp
hid="dbaccess/ui/dbaseindexdialog/table">Select the database table that you
want to index.</ahelp></paragraph>
-<bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/dbaseindexdialog/tableindex" id="bm_id3153312"
localize="false"/><paragraph role="heading" id="hd_id3159233" xml-lang="en-US"
level="2">Table Indexes</paragraph>
+<bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/dbaseindexdialog/tableindex" id="bm_id3153312"
localize="false"/><h2 id="hd_id3159233">Table Indexes</h2>
<paragraph role="paragraph" id="par_id3143267" xml-lang="en-US"><ahelp
hid="dbaccess/ui/dbaseindexdialog/tableindex">Lists the current indexes for the
selected database table.</ahelp> To remove an index from the list, click the
index, and then click the right arrow.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/freeindex"
id="bm_id3147276" localize="false"/><paragraph role="heading" id="hd_id3148538"
xml-lang="en-US" level="2">Free Indexes</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/freeindex"
id="bm_id3147276" localize="false"/><h2 id="hd_id3148538">Free Indexes</h2>
<paragraph role="paragraph" id="par_id3151110" xml-lang="en-US"><ahelp
hid="dbaccess/ui/dbaseindexdialog/freeindex">Lists the available indexes that
you can assign to a table.</ahelp> To assign an index to a selected table,
click the left arrow icon. The left double arrow assigns all available
indexes.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/add"
id="bm_id3146949" localize="false"/><paragraph role="heading" id="hd_id3156152"
xml-lang="en-US" level="2"><</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/add"
id="bm_id3146949" localize="false"/><h2 id="hd_id3156152"><</h2>
<paragraph role="paragraph" id="par_id3150984" xml-lang="en-US"><ahelp
hid="dbaccess/ui/dbaseindexdialog/add">Moves the selected index to the
<emph>Table Indexes</emph> list.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/addall"
id="bm_id3153147" localize="false"/><paragraph role="heading" id="hd_id3149416"
xml-lang="en-US" level="2"><<</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/addall"
id="bm_id3153147" localize="false"/><h2 id="hd_id3149416"><<</h2>
<paragraph role="paragraph" id="par_id3145315" xml-lang="en-US"><ahelp
hid="dbaccess/ui/dbaseindexdialog/addall">Moves all of the free indexes to the
<emph>Table Indexes</emph> list.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/remove"
id="bm_id3147619" localize="false"/><paragraph role="heading" id="hd_id3149579"
xml-lang="en-US" level="2">></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/remove"
id="bm_id3147619" localize="false"/><h2 id="hd_id3149579">></h2>
<paragraph role="paragraph" id="par_id3149795" xml-lang="en-US"><ahelp
hid="dbaccess/ui/dbaseindexdialog/remove">Moves the selected table indexes to
the <emph>Free Indexes</emph> list.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/removeall"
id="bm_id3154515" localize="false"/><paragraph role="heading" id="hd_id3155629"
xml-lang="en-US" level="2">>></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/removeall"
id="bm_id3154515" localize="false"/><h2 id="hd_id3155629">>></h2>
<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US"><ahelp
hid="dbaccess/ui/dbaseindexdialog/removeall">Moves all of the table indexes to
the <emph>Free Indexes</emph> list.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/explorer/database/11080000.xhp
b/source/text/sdatabase/11080000.xhp
similarity index 77%
rename from source/text/shared/explorer/database/11080000.xhp
rename to source/text/sdatabase/11080000.xhp
index 51fdbfced..c61aebd19 100644
--- a/source/text/shared/explorer/database/11080000.xhp
+++ b/source/text/sdatabase/11080000.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,20 +16,18 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabase11080000xml" indexer="include"
status="PUBLISH">
<title id="tit" xml-lang="en-US">Execute SQL statement</title>
-<filename>/text/shared/explorer/database/11080000.xhp</filename>
+<filename>/text/sdatabase/11080000.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index"
id="bm_id3148983"><bookmark_value>SQL; executing SQL statements
(Base)</bookmark_value>
<bookmark_value>databases; administration through SQL (Base)</bookmark_value>
</bookmark><bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/directsqldialog/DirectSQLDialog" id="bm_id3150773"
localize="false"/><paragraph role="paragraph" id="par_id3148983"
xml-lang="en-US" localize="false"/>
-<paragraph role="heading" id="hd_id3153345" xml-lang="en-US" level="1"><link
href="text/shared/explorer/database/11080000.xhp" name="Execute SQL
statement">Execute SQL statement</link></paragraph>
+<h1 id="hd_id3153345"><link href="text/sdatabase/11080000.xhp" name="Execute
SQL statement">Execute SQL statement</link></h1>
<paragraph role="paragraph" id="par_id3154288" xml-lang="en-US"><variable
id="sqltext"><ahelp hid=".">Opens a dialog where you can enter an SQL command
for administering a database.</ahelp>
</variable></paragraph>
<section id="howtoget">
@@ -40,17 +35,17 @@
</section>
<embed href="text/shared/guide/data_enter_sql.xhp#data_enter_sql"/>
<paragraph role="paragraph" id="par_id3147275" xml-lang="en-US">You can only
enter administration commands in this dialog, such as Grant, Create Table, or
Drop Table, and not filter commands. The commands that you can enter depend on
the data source, for example, dBASE can only run some of the SQL commands list
here.</paragraph>
-<paragraph role="note" id="par_id3154860" xml-lang="en-US">To run an SQL query
for filtering data in the database, use the <link
href="text/sdatabase/02010100.xhp" name="Query Design">Query Design
View</link>.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/sql"
id="bm_id3150772" localize="false"/><paragraph role="heading" id="hd_id3149514"
xml-lang="en-US" level="2">Command to execute</paragraph>
+<note id="par_id3154860">To run an SQL query for filtering data in the
database, use the <link href="text/sdatabase/02010100.xhp" name="Query
Design">Query Design View</link>.</note>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/sql"
id="bm_id3150772" localize="false"/><h2 id="hd_id3149514">Command to
execute</h2>
<paragraph role="paragraph" id="par_id3147618" xml-lang="en-US"><ahelp
hid="dbaccess/ui/directsqldialog/sql">Enter the SQL administration command that
you want to run.</ahelp></paragraph>
<paragraph role="paragraph" id="par_id3153087" xml-lang="en-US">For example,
for a "Bibliography" data source, you can enter the following SQL
command:</paragraph>
<paragraph role="paragraph" id="par_id3145673" xml-lang="en-US">SELECT
"Address" FROM "biblio" "biblio"</paragraph>
<paragraph role="paragraph" id="par_id3145611" xml-lang="en-US">For more
information on SQL commands, please consult the documentation that came with
the database.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/sqlhistory"
id="bm_id3154923" localize="false"/><paragraph role="heading" id="hd_id3156024"
xml-lang="en-US" level="2">Previous commands</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/sqlhistory"
id="bm_id3154923" localize="false"/><h2 id="hd_id3156024">Previous commands</h2>
<paragraph role="paragraph" id="par_id3149045" xml-lang="en-US"><ahelp
hid="dbaccess/ui/directsqldialog/sqlhistory">Lists the previously executed SQL
commands. To run a command again, click the command, and then click
<emph>Run</emph>.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/status"
id="bm_id3161656" localize="false"/><paragraph role="heading" id="hd_id3154348"
xml-lang="en-US" level="2">Status</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/status"
id="bm_id3161656" localize="false"/><h2 id="hd_id3154348">Status</h2>
<paragraph role="paragraph" id="par_id3151054" xml-lang="en-US"><ahelp
hid="dbaccess/ui/directsqldialog/status">Displays the results, including
errors, of the SQL command that you ran.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/execute"
id="bm_id3148798" localize="false"/><paragraph role="heading" id="hd_id3154071"
xml-lang="en-US" level="2">Run</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/execute"
id="bm_id3148798" localize="false"/><h2 id="hd_id3154071">Run</h2>
<paragraph role="paragraph" id="par_id3151210" xml-lang="en-US"><ahelp
hid="dbaccess/ui/directsqldialog/execute">Runs the command that you entered in
the <emph>Command to execute </emph>box.</ahelp></paragraph>
<embed href="text/shared/00/00000001.xhp#close2"/>
</body>
diff --git a/source/text/shared/explorer/database/11090000.xhp
b/source/text/sdatabase/11090000.xhp
similarity index 78%
rename from source/text/shared/explorer/database/11090000.xhp
rename to source/text/sdatabase/11090000.xhp
index 6b21741bf..e3b1db560 100644
--- a/source/text/shared/explorer/database/11090000.xhp
+++ b/source/text/sdatabase/11090000.xhp
@@ -1,7 +1,4 @@
<?xml version="1.0" encoding="UTF-8"?>
-
-
-
<!--
* This file is part of the LibreOffice project.
*
@@ -19,21 +16,19 @@
* 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">
+<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabase11090000xml" indexer="exclude"
status="PUBLISH">
<title id="tit" xml-lang="en-US">Table Filter</title>
-<filename>/text/shared/explorer/database/11090000.xhp</filename>
+<filename>/text/sdatabase/11090000.xhp</filename>
</topic>
</meta>
<body>
<section id="table_filter">
-<paragraph role="heading" id="hd_id3150702" xml-lang="en-US" level="1"><link
href="text/shared/explorer/database/11090000.xhp" name="Tables">Table
Filter</link></paragraph><comment>UFI: file remains as a help id container - no
browsing</comment></section>
+<h1 id="hd_id3150702"><link href="text/sdatabase/11090000.xhp"
name="Tables">Table Filter</link></h1><comment>UFI: file remains as a help id
container - no browsing</comment></section>
<bookmark xml-lang="en-US"
branch="hid/DBACCESS_HID_DSADMIN_SUPPRESS_VERSIONCL" id="bm_id3154046"
localize="false"/><paragraph role="paragraph" id="par_id3149164"
xml-lang="en-US"><ahelp hid="." visibility="hidden">Some databases track
changes to each record by assigning version number to fields that are changed.
This number is incremented by 1 each time the field is changed. Displays the
internal version number of the record in the database table.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/.uno:Sortup" id="bm_id5955967"
localize="false"/>
-<paragraph role="heading" id="hd_id3154923" xml-lang="en-US" level="2">Sort
Ascending<comment>in View - Sort menu</comment></paragraph>
+<h2 id="hd_id3154923">Sort Ascending<comment>in View - Sort menu</comment></h2>
<paragraph role="paragraph" id="par_id3147559" xml-lang="en-US"><ahelp
hid=".">Sorts the list of table names in ascending order starting at the
beginning of the alphabet.</ahelp></paragraph>
</body>
</helpdocument>
diff --git a/source/text/shared/02/12010000.xhp
b/source/text/shared/02/12010000.xhp
index a6b02a075..d2f045429 100644
--- a/source/text/shared/02/12010000.xhp
+++ b/source/text/shared/02/12010000.xhp
@@ -26,7 +26,7 @@
<body>
<section id="sortascending">
<h1 id="hd_id3152594"><link href="text/shared/02/12010000.xhp" name="Sort
Ascending">Sort Ascending</link></h1>
-<paragraph role="paragraph" id="par_id3150693" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Sorts the data of the selected field in ascending order.
</ahelp>Text fields are sorted alphabetically, numerical fields are sorted by
number.<comment>UFI: Help ID .uno:Sortup is found in
text/shared/explorer/database/11090000.xhp so I deleted it
here</comment></paragraph>
+<paragraph role="paragraph" id="par_id3150693" xml-lang="en-US"><ahelp hid="."
visibility="hidden">Sorts the data of the selected field in ascending order.
</ahelp>Text fields are sorted alphabetically, numerical fields are sorted by
number.<comment>UFI: Help ID .uno:Sortup is found in
text/sdatabase/11090000.xhp so I deleted it here</comment></paragraph>
</section>
<section id="howtoget">
<switch select="appl"><case select="CALC">
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
