From ed18f8e4f9fc516d1a9e117e983cdc8006838ad1 Mon Sep 17 00:00:00 2001
From: Olivier Hallot <olivier.hallot@libreoffice.org>
Date: Tue, 8 Jun 2021 09:14:19 -0300
Subject: Refactor some database help files

Change-Id: Ia9f3e2844cdf4ac16d7ee3ba70d64415c2bf964d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/116837
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
---
 AllLangHelp_sdatabase.mk                           |   3 +
 AllLangHelp_shared.mk                              |   3 -
 source/text/sdatabase/dabaadvprop.xhp              |  40 ++++++++
 source/text/sdatabase/dabaadvpropdat.xhp           | 108 +++++++++++++++++++++
 source/text/sdatabase/dabaadvpropgen.xhp           |  52 ++++++++++
 .../text/shared/explorer/database/dabaadvprop.xhp  |  43 --------
 .../shared/explorer/database/dabaadvpropdat.xhp    |  97 ------------------
 .../shared/explorer/database/dabaadvpropgen.xhp    |  49 ----------
 8 files changed, 203 insertions(+), 192 deletions(-)
 create mode 100644 source/text/sdatabase/dabaadvprop.xhp
 create mode 100644 source/text/sdatabase/dabaadvpropdat.xhp
 create mode 100644 source/text/sdatabase/dabaadvpropgen.xhp
 delete mode 100644 source/text/shared/explorer/database/dabaadvprop.xhp
 delete mode 100644 source/text/shared/explorer/database/dabaadvpropdat.xhp
 delete mode 100644 source/text/shared/explorer/database/dabaadvpropgen.xhp

diff --git a/AllLangHelp_sdatabase.mk b/AllLangHelp_sdatabase.mk
index b2723e0c47..337313b72e 100644
--- a/AllLangHelp_sdatabase.mk
+++ b/AllLangHelp_sdatabase.mk
@@ -45,6 +45,9 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sdatabase,\
     helpcontent2/source/text/sdatabase/11030100 \
     helpcontent2/source/text/sdatabase/11080000 \
     helpcontent2/source/text/sdatabase/11090000 \
+    helpcontent2/source/text/sdatabase/dabaadvpropdat \
+    helpcontent2/source/text/sdatabase/dabaadvpropgen \
+    helpcontent2/source/text/sdatabase/dabaadvprop \
 ))
 
 # vim: set noet sw=4 ts=4:
diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk
index 65feeac783..6ebe3e7db2 100644
--- a/AllLangHelp_shared.mk
+++ b/AllLangHelp_shared.mk
@@ -861,9 +861,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\
 ))
 
 $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\
-    helpcontent2/source/text/shared/explorer/database/dabaadvprop \
-    helpcontent2/source/text/shared/explorer/database/dabaadvpropdat \
-    helpcontent2/source/text/shared/explorer/database/dabaadvpropgen \
     helpcontent2/source/text/shared/explorer/database/dabadoc \
     helpcontent2/source/text/shared/explorer/database/dabaprop \
     helpcontent2/source/text/shared/explorer/database/dabapropadd \
diff --git a/source/text/sdatabase/dabaadvprop.xhp b/source/text/sdatabase/dabaadvprop.xhp
new file mode 100644
index 0000000000..fc008f5d58
--- /dev/null
+++ b/source/text/sdatabase/dabaadvprop.xhp
@@ -0,0 +1,40 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   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="textsharedexplorerdatabasedabaadvpropxml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Advanced Properties</title>
+<filename>/text/sdatabase/dabaadvprop.xhp</filename>
+</topic>
+<history>
+<created date="2004-07-30T11:15:17">Database advanced properties dialog</created>
+</history>
+</meta>
+<body>
+<section id="dabaadvprop">
+<h1 id="par_idN10550"><link href="text/sdatabase/dabaadvprop.xhp">Advanced Properties</link></h1>
+<paragraph role="paragraph" id="par_idN10560" xml-lang="en-US">Specifies advanced properties for the database.</paragraph>
+</section>
+<section id="howtoget">
+<paragraph role="paragraph" id="par_id3998840" xml-lang="en-US">In a database window, choose <emph>Edit - Database - Properties</emph>, click <emph>Advanced Properties</emph> tab</paragraph>
+</section>
+<embed href="text/sdatabase/dabaadvpropgen.xhp#generated"/>
+<embed href="text/sdatabase/dabaadvpropdat.xhp#data"/>
+</body>
+</helpdocument>
diff --git a/source/text/sdatabase/dabaadvpropdat.xhp b/source/text/sdatabase/dabaadvpropdat.xhp
new file mode 100644
index 0000000000..0a0e98f944
--- /dev/null
+++ b/source/text/sdatabase/dabaadvpropdat.xhp
@@ -0,0 +1,108 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   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="textsharedexplorerdatabasedabaadvpropdatxml" indexer="include">
+         <title xml-lang="en-US" id="tit">Special Settings</title>
+         <filename>/text/sdatabase/dabaadvpropdat.xhp</filename>
+      </topic>
+   </meta>
+   <body>
+     <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/SpecialSettingsPage" id="bm_id301592678856867" localize="false"/>
+     <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage//@@nowidget@@" id="bm_id971592679640715" localize="false"/>
+     <bookmark xml-lang="en-US" branch="index" id="bm_id81623155177507">
+         <bookmark_value>database;special settings</bookmark_value>
+         <bookmark_value>database settings;SQL92 naming</bookmark_value>
+         <bookmark_value>database settings;keyword AS</bookmark_value>
+         <bookmark_value>database settings;outer join syntax</bookmark_value>
+         <bookmark_value>database settings;special SELECT statements</bookmark_value>
+         <bookmark_value>database settings;ODBC date/time</bookmark_value>
+         <bookmark_value>database settings;support primary keys</bookmark_value>
+         <bookmark_value>database settings;line ends</bookmark_value>
+         <bookmark_value>database settings;version columns</bookmark_value>
+     </bookmark>
+      <section id="data">
+         <h1 id="par_idN10556"><link href="text/sdatabase/dabaadvpropdat.xhp">Special Settings</link></h1>
+         <paragraph xml-lang="en-US" id="par_idN10566" role="paragraph">Specifies the way you can work with data in a database.</paragraph>
+      </section>
+      <section id="howtoget">
+         <paragraph xml-lang="en-US" id="par_id7679372" role="paragraph">In a database window, choose <emph>Edit - Database - Advanced Settings</emph>
+         </paragraph>
+      </section>
+      <paragraph xml-lang="en-US" id="par_id4572283" role="paragraph">The availability of the following controls depends on the type of database:</paragraph>
+      <h2 id="par_idN10590">Use SQL92 naming constraints<comment>UFI: found this for dBase and for text file folder</comment></h2>
+      <paragraph xml-lang="en-US" id="par_idN10594" role="paragraph"><ahelp hid=".">Only allows characters that conform to the SQL92 naming convention in a name in a data source. All other characters are rejected. Each name must begin with a lowercase letter, an uppercase letter, or an underscore ( _ ). The remaining characters can be ASCII letters, numbers, and underscores.</ahelp></paragraph>
+      <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/useas" id="bm_id6617777328" localize="false"/>
+      <h2 id="par_idN105907">Use keyword AS before table alias names</h2>
+      <paragraph xml-lang="en-US" id="par_idN105947" role="paragraph"><ahelp hid=".">Some databases use the keyword "AS" between a name and its alias, while other databases use a whitespace. Enable this option to insert AS before the alias.</ahelp><comment>http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw</comment></paragraph>
+
+      <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/eol" id="bm_id6617328" localize="false"/>
+<h2 id="hd_id3534958">End text lines with CR + LF<comment>UFI: found for dBase and text file folder</comment></h2>
+      <paragraph xml-lang="en-US" id="par_id6151921" role="paragraph"><ahelp hid=".">Select to use the CR + LF code pair to end every text line (preferred for DOS and Windows operating systems).</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/append" id="bm_id9050569" localize="false"/>
+<h2 id="par_idN1059E">Append the table alias name in SELECT statements</h2>
+      <paragraph xml-lang="en-US" id="par_idN105A2" role="paragraph"><ahelp hid=".">Appends the alias to the table name in SELECT statements.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/useoj" id="bm_id7278664" localize="false"/>
+<h2 id="par_idN105A5">Use Outer Join syntax '{OJ }'</h2>
+      <paragraph xml-lang="en-US" id="par_idN105A9" role="paragraph"><ahelp hid=".">Use escape sequences for outer joins. The syntax for this escape sequence is {oj outer-join}</ahelp><comment>copied from shared\explorer\database\02010100.xhp</comment></paragraph>
+      <paragraph xml-lang="en-US" id="par_idN105BE" role="paragraph">Example:</paragraph>
+      <paragraph xml-lang="en-US" id="par_idN105C1" role="example">select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/ignoreprivs" id="bm_id3826715" localize="false"/>
+<h2 id="par_idN105C4">Ignore the privileges from the database driver</h2>
+      <paragraph xml-lang="en-US" id="par_idN105C8" role="paragraph"><ahelp hid=".">Ignores access privileges that are provided by the database driver.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/replaceparams" id="bm_id8939786" localize="false"/>
+<h2 id="par_idN105CB">Replace named parameters with ?</h2>
+      <paragraph xml-lang="en-US" id="par_idN105CF" role="paragraph"><ahelp hid=".">Replaces named parameters in a data source with a question mark (?).</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/displayver" id="bm_id6642353" localize="false"/>
+<h2 id="par_idN105D2">Display version columns (when available)</h2>
+      <paragraph xml-lang="en-US" id="par_idN105D6" role="paragraph">Some databases assign version numbers to fields to track changes to records. The version number of a field is incremented by one each time the contents of the field are changed. <ahelp hid="dbaccess/ui/specialsettingspage/displayver">Displays the internal version number of the record in the database table.</ahelp><comment>copied from shared\explorer\database\11090000.xhp</comment></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/usecatalogname" id="bm_id2444532" localize="false"/>
+<h2 id="par_idN105FA">Use the catalog name in SELECT statements</h2>
+      <paragraph xml-lang="en-US" id="par_idN105FE" role="paragraph"><ahelp hid=".">Uses the current data source of the catalog. This option is useful when the ODBC data source is a database server. Do not select this option if the ODBC data source is a dBASE driver.</ahelp><comment>copie from shared\explorer\database\11020000.xhp</comment></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/useschemaname" id="bm_id7354655" localize="false"/>
+<h2 id="par_idN10613">Use the schema name in SELECT statements</h2>
+      <paragraph xml-lang="en-US" id="par_idN10617" role="paragraph"><ahelp hid=".">Allows you to use the schema name in SELECT statements.</ahelp><comment>UFI: ???</comment></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/createindex" id="bm_id321665" localize="false"/>
+<h2 id="par_idN1061A">Create index with ASC or DESC statement</h2>
+      <paragraph xml-lang="en-US" id="par_idN1061E" role="paragraph"><ahelp hid=".">Creates an index with ASC or DESC statements.</ahelp><comment>UFI: ???</comment></paragraph>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_BOOLEANCOMPARISON" id="bm_id5289773" localize="false"/>
+<h2 id="par_idN10621">Comparison of Boolean values</h2>
+      <paragraph xml-lang="en-US" id="par_idN10625" role="paragraph"><ahelp hid=".">Select the type of Boolean comparison that you want to use.</ahelp><comment>UFI: ???</comment></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/inputchecks" id="bm_id4741355" localize="false"/>
+<h2 id="hd_id1101718">Form data input checks for required fields<comment>i82291</comment></h2>
+      <paragraph xml-lang="en-US" id="par_id3783989" role="paragraph"><ahelp hid=".">When you enter a new record or update an existing record in a form, and you leave a field empty which is bound to a database column which requires input, then you will see a message complaining about the empty field.</ahelp></paragraph>
+      <paragraph xml-lang="en-US" id="par_id6684163" role="paragraph">If this control box is not enabled, then the forms in the current database will not be checked for required fields.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3837397" role="paragraph">The control box is available for all data source types which support write access to their data. The control box does not exist for spreadsheets, text, csv, and the various read-only address books.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/ignorecurrency" id="bm_id4741356" localize="false"/>
+      <h2 id="hd_id0909200811170166">Ignore currency field information</h2>
+      <paragraph xml-lang="en-US" id="par_id0909200811170221" role="paragraph"><ahelp hid=".">Only for Oracle JDBC connections. When enabled it specifies that no column is treated as a currency field. The field type returned from the database driver is discarded.</ahelp></paragraph>
+
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/useodbcliterals" id="bm_id4743451355" localize="false"/>
+<h2 id="hd_id040920092139524">Use ODBC conformant date/time literals</h2>
+<paragraph xml-lang="en-US" id="par_id040920092139526" role="paragraph"><ahelp hid=".">Use date/time literals that conform to ODBC standard.</ahelp></paragraph>
+
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/primarykeys" id="bm_id47434523231355" localize="false"/>
+<h2 id="hd_id04092009442139524">Supports primary keys</h2>
+<paragraph xml-lang="en-US" id="par_id04096620092139526" role="paragraph"><ahelp hid=".">Enable to overrule Base's heuristics used to detect whether the database supports primary keys.</ahelp></paragraph>
+<paragraph xml-lang="en-US" id="par_id66841631" role="paragraph">When connecting to a database using a generic API like ODBC, JDBC, or ADO, Base currently applies heuristics to determine whether this database supports primary keys. None of those APIs has dedicated support to retrieve this information.</paragraph>
+<paragraph xml-lang="en-US" id="par_id66841632" role="paragraph">The heuristics sometimes fails. This tri-state check box by default is set to the undetermined state, which means "apply the heuristics". If the check box is enabled, primary key support is assumed. If the check box is disabled, no primary key support is assumed.</paragraph>
+<paragraph xml-lang="en-US" id="par_id66841633" role="paragraph">Note that if this option is just for overruling the heuristics. If you enable the check box for a database which actually does not support primary keys, you will see some errors.</paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/sdatabase/dabaadvpropgen.xhp b/source/text/sdatabase/dabaadvpropgen.xhp
new file mode 100644
index 0000000000..d9312dc5e5
--- /dev/null
+++ b/source/text/sdatabase/dabaadvpropgen.xhp
@@ -0,0 +1,52 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   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="textsharedexplorerdatabasedabaadvpropgenxml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Generated Values</title>
+<filename>/text/sdatabase/dabaadvpropgen.xhp</filename>
+</topic>
+<history>
+<created date="2004-07-30T11:20:09">Advanced Properties dialog Generated values tab page</created>
+</history>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id521623154765032">
+    <bookmark_value>database advanced properties;autoincrement values</bookmark_value>
+    <bookmark_value>database advanced properties;automatic generated values</bookmark_value>
+    <bookmark_value>database advanced properties;retrieve generated values</bookmark_value>
+    <bookmark_value>database advanced properties;query generated values</bookmark_value>
+</bookmark>
+<section id="generated">
+<h1 id="par_idN10553"><link href="text/sdatabase/dabaadvpropgen.xhp">Generated Values</link></h1>
+<paragraph role="paragraph" id="par_idN10563" xml-lang="en-US">Specifies the options for automatically generated values for new data records.<comment>UFI: all text copied from shared\explorer\database\11020000.xhp</comment></paragraph>
+</section>
+<paragraph role="paragraph" id="par_idN10578" xml-lang="en-US" localize="false"><comment>how to get this: Edit Database AdvancedProp ??? I have no idea</comment></paragraph>
+<paragraph role="paragraph" id="par_id7684560" xml-lang="en-US">The availability of the following controls depends on the type of database:</paragraph>
+<h2 id="par_idN1058C">Retrieve generated values</h2>
+<paragraph role="paragraph" id="par_idN10590" xml-lang="en-US"><ahelp hid=".">Enables $[officename] support for auto-incremented data fields in the current ODBC or JDBC data source. Select this option if the auto-increment feature in the SDBCX layer of the database is not supported. In general<comment>UFI: this does not mean that something is set by default, but "normally,"</comment>, the auto-increment is selected for the primary key field.</ahelp></paragraph>
+<h2 id="par_idN10593">Auto-increment statement</h2>
+<paragraph role="paragraph" id="par_idN10597" xml-lang="en-US"><ahelp hid=".">Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field.</ahelp> For example, the following MySQL statement used the AUTO_INCREMENT statement to increase the "id" field each time the statement creates a data field:</paragraph>
+<paragraph role="code" id="par_idN105A0" xml-lang="en-US">CREATE TABLE "table1" ("id" INTEGER AUTO_INCREMENT)</paragraph>
+<paragraph role="paragraph" id="par_idN10634" xml-lang="en-US">For this example, you must enter AUTO_INCREMENT into the <emph>Auto-increment statement</emph> box.</paragraph>
+<h2 id="par_idN105AA">Query of generated values</h2>
+<paragraph role="paragraph" id="par_idN10645" xml-lang="en-US"><ahelp hid=".">Enter an SQL statement that returns the last auto-incremented value for the primary key data field.</ahelp> For example:</paragraph>
+<paragraph role="code" id="par_idN105B1" xml-lang="en-US">SELECT LAST_INSERT_D();</paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/shared/explorer/database/dabaadvprop.xhp b/source/text/shared/explorer/database/dabaadvprop.xhp
deleted file mode 100644
index ee8535766e..0000000000
--- a/source/text/shared/explorer/database/dabaadvprop.xhp
+++ /dev/null
@@ -1,43 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-
-
-<!--
- * This file is part of the LibreOffice project.
- *
- * This Source Code Form is subject to the terms of the Mozilla Public
- * License, v. 2.0. If a copy of the MPL was not distributed with this
- * file, You can obtain one at http://mozilla.org/MPL/2.0/.
- *
- * This file incorporates work covered by the following license notice:
- *
- *   Licensed to the Apache Software Foundation (ASF) under one or more
- *   contributor license agreements. See the NOTICE file distributed
- *   with this work for additional information regarding copyright
- *   ownership. The ASF licenses this file to you under the Apache
- *   License, Version 2.0 (the "License"); you may not use this file
- *   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="textsharedexplorerdatabasedabaadvpropxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Advanced Properties</title>
-<filename>/text/shared/explorer/database/dabaadvprop.xhp</filename>
-</topic>
-<history>
-<created date="2004-07-30T11:15:17">Database advanced properties dialog</created>
-</history>
-</meta>
-<body>
-<section id="dabaadvprop">
-<paragraph role="heading" id="par_idN10550" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/dabaadvprop.xhp">Advanced Properties</link></paragraph>
-<paragraph role="paragraph" id="par_idN10560" xml-lang="en-US">Specifies advanced properties for the database.</paragraph>
-</section>
-<section id="howtoget">
-<paragraph role="paragraph" id="par_id3998840" xml-lang="en-US">In a database window, choose <emph>Edit - Database - Properties</emph>, click <emph>Advanced Properties</emph> tab</paragraph>
-</section>
-<embed href="text/shared/explorer/database/dabaadvpropgen.xhp#generated"/>
-<embed href="text/shared/explorer/database/dabaadvpropdat.xhp#data"/>
-</body>
-</helpdocument>
diff --git a/source/text/shared/explorer/database/dabaadvpropdat.xhp b/source/text/shared/explorer/database/dabaadvpropdat.xhp
deleted file mode 100644
index 399a8693d0..0000000000
--- a/source/text/shared/explorer/database/dabaadvpropdat.xhp
+++ /dev/null
@@ -1,97 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<helpdocument version="1.0">
-
-<!--
- * This file is part of the LibreOffice project.
- *
- * This Source Code Form is subject to the terms of the Mozilla Public
- * License, v. 2.0. If a copy of the MPL was not distributed with this
- * file, You can obtain one at http://mozilla.org/MPL/2.0/.
- *
- * This file incorporates work covered by the following license notice:
- *
- *   Licensed to the Apache Software Foundation (ASF) under one or more
- *   contributor license agreements. See the NOTICE file distributed
- *   with this work for additional information regarding copyright
- *   ownership. The ASF licenses this file to you under the Apache
- *   License, Version 2.0 (the "License"); you may not use this file
- *   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="textsharedexplorerdatabasedabaadvpropdatxml" indexer="include">
-         <title xml-lang="en-US" id="tit">Special Settings</title>
-         <filename>/text/shared/explorer/database/dabaadvpropdat.xhp</filename>
-      </topic>
-   </meta>
-   <body>
-     <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/SpecialSettingsPage" id="bm_id301592678856867" localize="false"/>
-     <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage//@@nowidget@@" id="bm_id971592679640715" localize="false"/>
-      <section id="data">
-         <h1 id="par_idN10556"><link href="text/shared/explorer/database/dabaadvpropdat.xhp">Special Settings</link></h1>
-         <paragraph xml-lang="en-US" id="par_idN10566" role="paragraph">Specifies the way you can work with data in a database.</paragraph>
-      </section>
-      <section id="howtoget">
-         <paragraph xml-lang="en-US" id="par_id7679372" role="paragraph">In a database window, choose <emph>Edit - Database - Advanced Settings</emph>
-         </paragraph>
-      </section>
-      <paragraph xml-lang="en-US" id="par_id4572283" role="paragraph">The availability of the following controls depends on the type of database:</paragraph>
-      <h2 id="par_idN10590">Use SQL92 naming constraints<comment>UFI: found this for dBase and for text file folder</comment></h2>
-      <paragraph xml-lang="en-US" id="par_idN10594" role="paragraph"><ahelp hid=".">Only allows characters that conform to the SQL92 naming convention in a name in a data source. All other characters are rejected. Each name must begin with a lowercase letter, an uppercase letter, or an underscore ( _ ). The remaining characters can be ASCII letters, numbers, and underscores.</ahelp></paragraph>
-      <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/useas" id="bm_id6617777328" localize="false"/>
-      <h2 id="par_idN105907">Use keyword AS before table alias names</h2>
-      <paragraph xml-lang="en-US" id="par_idN105947" role="paragraph"><ahelp hid=".">Some databases use the keyword "AS" between a name and its alias, while other databases use a whitespace. Enable this option to insert AS before the alias.</ahelp><comment>http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw</comment></paragraph>
-
-      <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/eol" id="bm_id6617328" localize="false"/>
-<h2 id="hd_id3534958">End text lines with CR + LF<comment>UFI: found for dBase and text file folder</comment></h2>
-      <paragraph xml-lang="en-US" id="par_id6151921" role="paragraph"><ahelp hid=".">Select to use the CR + LF code pair to end every text line (preferred for DOS and Windows operating systems).</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/append" id="bm_id9050569" localize="false"/>
-<h2 id="par_idN1059E">Append the table alias name in SELECT statements</h2>
-      <paragraph xml-lang="en-US" id="par_idN105A2" role="paragraph"><ahelp hid=".">Appends the alias to the table name in SELECT statements.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/useoj" id="bm_id7278664" localize="false"/>
-<h2 id="par_idN105A5">Use Outer Join syntax '{OJ }'</h2>
-      <paragraph xml-lang="en-US" id="par_idN105A9" role="paragraph"><ahelp hid=".">Use escape sequences for outer joins. The syntax for this escape sequence is {oj outer-join}</ahelp><comment>copied from shared\explorer\database\02010100.xhp</comment></paragraph>
-      <paragraph xml-lang="en-US" id="par_idN105BE" role="paragraph">Example:</paragraph>
-      <paragraph xml-lang="en-US" id="par_idN105C1" role="example">select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/ignoreprivs" id="bm_id3826715" localize="false"/>
-<h2 id="par_idN105C4">Ignore the privileges from the database driver</h2>
-      <paragraph xml-lang="en-US" id="par_idN105C8" role="paragraph"><ahelp hid=".">Ignores access privileges that are provided by the database driver.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/replaceparams" id="bm_id8939786" localize="false"/>
-<h2 id="par_idN105CB">Replace named parameters with ?</h2>
-      <paragraph xml-lang="en-US" id="par_idN105CF" role="paragraph"><ahelp hid=".">Replaces named parameters in a data source with a question mark (?).</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/displayver" id="bm_id6642353" localize="false"/>
-<h2 id="par_idN105D2">Display version columns (when available)</h2>
-      <paragraph xml-lang="en-US" id="par_idN105D6" role="paragraph">Some databases assign version numbers to fields to track changes to records. The version number of a field is incremented by one each time the contents of the field are changed. <ahelp hid="dbaccess/ui/specialsettingspage/displayver">Displays the internal version number of the record in the database table.</ahelp><comment>copied from shared\explorer\database\11090000.xhp</comment></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/usecatalogname" id="bm_id2444532" localize="false"/>
-<h2 id="par_idN105FA">Use the catalog name in SELECT statements</h2>
-      <paragraph xml-lang="en-US" id="par_idN105FE" role="paragraph"><ahelp hid=".">Uses the current data source of the catalog. This option is useful when the ODBC data source is a database server. Do not select this option if the ODBC data source is a dBASE driver.</ahelp><comment>copie from shared\explorer\database\11020000.xhp</comment></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/useschemaname" id="bm_id7354655" localize="false"/>
-<h2 id="par_idN10613">Use the schema name in SELECT statements</h2>
-      <paragraph xml-lang="en-US" id="par_idN10617" role="paragraph"><ahelp hid=".">Allows you to use the schema name in SELECT statements.</ahelp><comment>UFI: ???</comment></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/createindex" id="bm_id321665" localize="false"/>
-<h2 id="par_idN1061A">Create index with ASC or DESC statement</h2>
-      <paragraph xml-lang="en-US" id="par_idN1061E" role="paragraph"><ahelp hid=".">Creates an index with ASC or DESC statements.</ahelp><comment>UFI: ???</comment></paragraph>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_BOOLEANCOMPARISON" id="bm_id5289773" localize="false"/>
-<h2 id="par_idN10621">Comparison of Boolean values</h2>
-      <paragraph xml-lang="en-US" id="par_idN10625" role="paragraph"><ahelp hid=".">Select the type of Boolean comparison that you want to use.</ahelp><comment>UFI: ???</comment></paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/inputchecks" id="bm_id4741355" localize="false"/>
-<h2 id="hd_id1101718">Form data input checks for required fields<comment>i82291</comment></h2>
-      <paragraph xml-lang="en-US" id="par_id3783989" role="paragraph"><ahelp hid=".">When you enter a new record or update an existing record in a form, and you leave a field empty which is bound to a database column which requires input, then you will see a message complaining about the empty field.</ahelp></paragraph>
-      <paragraph xml-lang="en-US" id="par_id6684163" role="paragraph">If this control box is not enabled, then the forms in the current database will not be checked for required fields.</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3837397" role="paragraph">The control box is available for all data source types which support write access to their data. The control box does not exist for spreadsheets, text, csv, and the various read-only address books.</paragraph>
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/ignorecurrency" id="bm_id4741356" localize="false"/>
-      <h2 id="hd_id0909200811170166">Ignore currency field information</h2>
-      <paragraph xml-lang="en-US" id="par_id0909200811170221" role="paragraph"><ahelp hid=".">Only for Oracle JDBC connections. When enabled it specifies that no column is treated as a currency field. The field type returned from the database driver is discarded.</ahelp></paragraph>
-
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/useodbcliterals" id="bm_id4743451355" localize="false"/>
-<h2 id="hd_id040920092139524">Use ODBC conformant date/time literals</h2>
-<paragraph xml-lang="en-US" id="par_id040920092139526" role="paragraph"><ahelp hid=".">Use date/time literals that conform to ODBC standard.</ahelp></paragraph>
-
-<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/primarykeys" id="bm_id47434523231355" localize="false"/>
-<h2 id="hd_id04092009442139524">Supports primary keys</h2>
-<paragraph xml-lang="en-US" id="par_id04096620092139526" role="paragraph"><ahelp hid=".">Enable to overrule Base's heuristics used to detect whether the database supports primary keys.</ahelp></paragraph>
-<paragraph xml-lang="en-US" id="par_id66841631" role="paragraph">When connecting to a database using a generic API like ODBC, JDBC, or ADO, Base currently applies heuristics to determine whether this database supports primary keys. None of those APIs has dedicated support to retrieve this information.</paragraph>
-<paragraph xml-lang="en-US" id="par_id66841632" role="paragraph">The heuristics sometimes fails. This tri-state check box by default is set to the undetermined state, which means "apply the heuristics". If the check box is enabled, primary key support is assumed. If the check box is disabled, no primary key support is assumed.</paragraph>
-<paragraph xml-lang="en-US" id="par_id66841633" role="paragraph">Note that if this option is just for overruling the heuristics. If you enable the check box for a database which actually does not support primary keys, you will see some errors.</paragraph>
-</body>
-</helpdocument>
diff --git a/source/text/shared/explorer/database/dabaadvpropgen.xhp b/source/text/shared/explorer/database/dabaadvpropgen.xhp
deleted file mode 100644
index 8627519bce..0000000000
--- a/source/text/shared/explorer/database/dabaadvpropgen.xhp
+++ /dev/null
@@ -1,49 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-
-
-<!--
- * This file is part of the LibreOffice project.
- *
- * This Source Code Form is subject to the terms of the Mozilla Public
- * License, v. 2.0. If a copy of the MPL was not distributed with this
- * file, You can obtain one at http://mozilla.org/MPL/2.0/.
- *
- * This file incorporates work covered by the following license notice:
- *
- *   Licensed to the Apache Software Foundation (ASF) under one or more
- *   contributor license agreements. See the NOTICE file distributed
- *   with this work for additional information regarding copyright
- *   ownership. The ASF licenses this file to you under the Apache
- *   License, Version 2.0 (the "License"); you may not use this file
- *   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="textsharedexplorerdatabasedabaadvpropgenxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Generated Values</title>
-<filename>/text/shared/explorer/database/dabaadvpropgen.xhp</filename>
-</topic>
-<history>
-<created date="2004-07-30T11:20:09">Advanced Properties dialog Generated values tab page</created>
-</history>
-</meta>
-<body>
-<section id="generated">
-<paragraph role="heading" id="par_idN10553" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/dabaadvpropgen.xhp">Generated Values</link></paragraph>
-<paragraph role="paragraph" id="par_idN10563" xml-lang="en-US">Specifies the options for automatically generated values for new data records.<comment>UFI: all text copied from shared\explorer\database\11020000.xhp</comment></paragraph>
-</section>
-<paragraph role="paragraph" id="par_idN10578" xml-lang="en-US" localize="false"><comment>how to get this: Edit Database AdvancedProp ??? I have no idea</comment></paragraph>
-<paragraph role="paragraph" id="par_id7684560" xml-lang="en-US">The availability of the following controls depends on the type of database:</paragraph>
-<paragraph role="heading" id="par_idN1058C" xml-lang="en-US" level="2">Retrieve generated values</paragraph>
-<paragraph role="paragraph" id="par_idN10590" xml-lang="en-US"><ahelp hid=".">Enables $[officename] support for auto-incremented data fields in the current ODBC or JDBC data source. Select this option if the auto-increment feature in the SDBCX layer of the database is not supported. In general<comment>UFI: this does not mean that something is set by default, but "normally,"</comment>, the auto-increment is selected for the primary key field.</ahelp></paragraph>
-<paragraph role="heading" id="par_idN10593" xml-lang="en-US" level="2">Auto-increment statement</paragraph>
-<paragraph role="paragraph" id="par_idN10597" xml-lang="en-US"><ahelp hid=".">Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field.</ahelp> For example, the following MySQL statement used the AUTO_INCREMENT statement to increase the "id" field each time the statement creates a data field:</paragraph>
-<paragraph role="code" id="par_idN105A0" xml-lang="en-US">CREATE TABLE "table1" ("id" INTEGER AUTO_INCREMENT)</paragraph>
-<paragraph role="paragraph" id="par_idN10634" xml-lang="en-US">For this example, you must enter AUTO_INCREMENT into the <emph>Auto-increment statement</emph> box.</paragraph>
-<paragraph role="heading" id="par_idN105AA" xml-lang="en-US" level="2">Query of generated values</paragraph>
-<paragraph role="paragraph" id="par_idN10645" xml-lang="en-US"><ahelp hid=".">Enter an SQL statement that returns the last auto-incremented value for the primary key data field.</ahelp> For example:</paragraph>
-<paragraph role="code" id="par_idN105B1" xml-lang="en-US">SELECT LAST_INSERT_D();</paragraph>
-</body>
-</helpdocument>
-- 
cgit