source/text/shared/explorer/database/dabaadvpropdat.xhp | 39 +++++++---------
1 file changed, 19 insertions(+), 20 deletions(-)
New commits:
commit 3512ddac6810ba61d89e843c3b010d1354720deb
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Sat Jun 20 19:04:12 2020 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Jun 22 15:17:27 2020 +0200
tdf#124010 Missing bookmark for adv database settings
Change-Id: Ibab5140c0095dbdc46fae02268b5c51e251be0b8
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/96783
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/shared/explorer/database/dabaadvpropdat.xhp
b/source/text/shared/explorer/database/dabaadvpropdat.xhp
index b1e0f3664..399a8693d 100644
--- a/source/text/shared/explorer/database/dabaadvpropdat.xhp
+++ b/source/text/shared/explorer/database/dabaadvpropdat.xhp
@@ -18,8 +18,6 @@
* 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>
@@ -27,8 +25,10 @@
</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">
- <paragraph xml-lang="en-US" id="par_idN10556" role="heading"
level="1"><link href="text/shared/explorer/database/dabaadvpropdat.xhp">Special
Settings</link></paragraph>
+ <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">
@@ -36,60 +36,59 @@
</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>
- <paragraph xml-lang="en-US" id="par_idN10590" role="heading"
level="2">Use SQL92 naming constraints<comment>UFI: found this for dBase and
for text file folder</comment></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"/>
- <paragraph xml-lang="en-US" id="par_idN105907" role="heading"
level="2">Use keyword AS before table alias names</paragraph>
+ <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"/>
-<paragraph xml-lang="en-US" id="hd_id3534958" role="heading" level="2">End
text lines with CR + LF<comment>UFI: found for dBase and text file
folder</comment></paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="par_idN1059E" role="heading" level="2">Append
the table alias name in SELECT statements</paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="par_idN105A5" role="heading" level="2">Use
Outer Join syntax '{OJ }'</paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="par_idN105C4" role="heading" level="2">Ignore
the privileges from the database driver</paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="par_idN105CB" role="heading" level="2">Replace
named parameters with ?</paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="par_idN105D2" role="heading" level="2">Display
version columns (when available)</paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="par_idN105FA" role="heading" level="2">Use the
catalog name in SELECT statements</paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="par_idN10613" role="heading" level="2">Use the
schema name in SELECT statements</paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="par_idN1061A" role="heading" level="2">Create
index with ASC or DESC statement</paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="par_idN10621" role="heading"
level="2">Comparison of Boolean values</paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="hd_id1101718" role="heading" level="2">Form
data input checks for required fields<comment>i82291</comment></paragraph>
+<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"/>
- <paragraph xml-lang="en-US" id="hd_id0909200811170166" role="heading"
level="2">Ignore currency field information</paragraph>
+ <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"/>
-<paragraph xml-lang="en-US" id="hd_id040920092139524" role="heading"
level="2">Use ODBC conformant date/time literals</paragraph>
+<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"/>
-<paragraph xml-lang="en-US" id="hd_id04092009442139524" role="heading"
level="2">Supports primary keys</paragraph>
+<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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
