source/text/sdatabase/dabaadvpropdat.xhp | 228 ++++++++++++++++---------------
1 file changed, 125 insertions(+), 103 deletions(-)
New commits:
commit 7a89e385e842191c215e407541a96343fbb5dc97
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Mon Sep 27 12:40:41 2021 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Tue Sep 28 15:22:59 2021 +0200
tdf#144712 Database Advanced Settings: Help Inconsistent
Update and fix order of the dialog settings
Add missing settings entries in Help page
Change-Id: Ia763d1e63f286fa819fb6eadc820e788e371e921
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/122718
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/sdatabase/dabaadvpropdat.xhp
b/source/text/sdatabase/dabaadvpropdat.xhp
index 0a0e98f94..bfe2fa07b 100644
--- a/source/text/sdatabase/dabaadvpropdat.xhp
+++ b/source/text/sdatabase/dabaadvpropdat.xhp
@@ -1,108 +1,130 @@
<?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>
+ <!--
+ * 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/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/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/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/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/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/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/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>
+
+ <bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/specialsettingspage/resulttype"
id="bm_id751632741084270" localize="false"/>
+ <h2 id="hd_id621632736570505">Respect the result set type from the
database driver</h2>
+ <comment>OH: Could not find a clear definition of this setting, best so
far is
https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1sdbc_1_1ResultSetType.html</comment>
+ <paragraph role="paragraph" id="par_id641632755407673">Use the database
driver different scroll capabilities of a result set. Refer to <link
href="https://api.libreoffice.org/docs/idl/ref/namespacecom_1_1sun_1_1star_1_1sdbc_1_1ResultSetType.html";
name="ResultSetType">ResultSetType Constant Group</link></paragraph>
+
+ <bookmark xml-lang="en-US"
branch="hid/DBACCESS_HID_DSADMIN_BOOLEANCOMPARISON" id="bm_id5289773"
localize="false"/>
+ <bookmark xml-lang="en-US"
branch="hid/dbaccess/ui/specialsettingspage/comparison"
id="bm_id501632740974366" 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/rows" id="bm_id421632741122510"
localize="false"/>
+ <h2 id="hd_id421632739992940">Rows to scan columns types</h2>
+ <paragraph role="paragraph" id="par_id541632740596622">Select the number
of rows to let the driver detect the data type.</paragraph>
</body>
</helpdocument>
