source/text/sdatabase/05030300.xhp | 5 ++
source/text/sdatabase/tablewizard02.xhp | 54 ++++++++++++++++----------------
2 files changed, 31 insertions(+), 28 deletions(-)
New commits:
commit ec63fc11d91d92f31fd7aca15820fafd84d2c957
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Thu Sep 12 08:42:24 2024 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Sep 12 14:59:46 2024 +0200
tdf#162607 Remove dup's in hid2file.js, DBACCESS_HID*
+ bad bookmarks removed from tablewizard02.xhp
+ refactor
Change-Id: I6aa3aa5c339319ad6c9d330986168d3c347a57c8
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/173259
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
diff --git a/source/text/sdatabase/05030300.xhp
b/source/text/sdatabase/05030300.xhp
index 1c94019eb4..73c4bfbca2 100644
--- a/source/text/sdatabase/05030300.xhp
+++ b/source/text/sdatabase/05030300.xhp
@@ -27,14 +27,17 @@
</history>
</meta>
<body>
+
+<bookmark branch="hid/hid/dbaccess/ui/fieldselectpage/@@nowidget@@"
id="bm_id291726140024202" localize="false"/>
<section id="tablecopy3">
<h1 id="hd_id3163829"><link href="text/sdatabase/05030300.xhp">Type
formatting</link></h1>
<paragraph role="paragraph" id="par_id3150247">In the data source explorer,
you can copy a table by dragging and dropping the table onto the table
container. The<emph> Type formatting </emph>dialog is the third window of the
<emph>Copy table</emph> dialog.</paragraph>
</section>
<bookmark branch="hid/dbaccess/ui/typeselectpage/columnnames"
id="bm_id3147291" localize="false"/>
-<h2 id="hd_id3152801">List box</h2>
+<h2 id="hd_id3152801">Field list</h2>
<paragraph role="paragraph" id="par_id3145313"><ahelp
hid="dbaccess/ui/typeselectpage/columnnames">Lists the data fields that will be
included in to the copied table.</ahelp></paragraph>
<h2 id="hd_id3155535">Column information</h2>
+
<bookmark branch="hid/DBACCESS_HID_TAB_ENT_COLUMNNAME" id="bm_id3153311"
localize="false"/>
<h3 id="hd_id3156426">Field name</h3>
<paragraph role="paragraph" id="par_id3153681"><ahelp hid=".">Displays the
name of the selected data field. If you want, you can enter a new
name.</ahelp></paragraph>
diff --git a/source/text/sdatabase/tablewizard02.xhp
b/source/text/sdatabase/tablewizard02.xhp
index 05fa1f89e4..3b97ed1c94 100644
--- a/source/text/sdatabase/tablewizard02.xhp
+++ b/source/text/sdatabase/tablewizard02.xhp
@@ -19,45 +19,45 @@
<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabasetablewizard02xml" indexer="include"
status="PUBLISH">
-<title id="tit" xml-lang="en-US">Table Wizard - Set Types and Formats</title>
+<title id="tit">Table Wizard - Set Types and Formats</title>
<filename>/text/sdatabase/tablewizard02.xhp</filename>
</topic>
</meta>
<body>
<section id="settype">
<h1 id="par_idN10552"><link href="text/sdatabase/tablewizard02.xhp">Table
Wizard - Set Types and Formats</link></h1>
-<paragraph role="paragraph" id="par_idN10562" xml-lang="en-US">Specifies the
field information for your selected fields.</paragraph>
+<paragraph role="paragraph" id="par_idN10562">Specifies the field information
for your selected fields.</paragraph>
</section>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_LB_SELFIELDNAMES"
id="bm_id5365764" localize="false"/><h2 id="par_idN10565">Selected fields</h2>
-<paragraph role="paragraph" id="par_idN10569" xml-lang="en-US"><ahelp
hid=".">Select a field in order to edit the field
information.</ahelp></paragraph>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_LB_SELFIELDNAMES" id="bm_id5365764"
localize="false"/><h2 id="par_idN10565">Selected fields</h2>
+<paragraph role="paragraph" id="par_idN10569"><ahelp hid=".">Select a field in
order to edit the field information.</ahelp></paragraph>
<embed href="text/shared/autopi/01090100.xhp#updown"/>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDMINUS"
id="bm_id8947111.00000001" localize="false"/><h3 id="par_idN10574">−</h3>
-<paragraph role="paragraph" id="par_idN10578" xml-lang="en-US"><ahelp
hid=".">Remove the selected field from the list box.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_CMDPLUS"
id="bm_id7230140" localize="false"/><h3 id="par_idN1057B">+</h3>
-<paragraph role="paragraph" id="par_idN1057F" xml-lang="en-US"><ahelp
hid=".">Add a new data field to the list box.</ahelp></paragraph>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_CMDMINUS"
id="bm_id8947111.00000001" localize="false"/><h3 id="par_idN10574">−</h3>
+<paragraph role="paragraph" id="par_idN10578"><ahelp hid=".">Remove the
selected field from the list box.</ahelp></paragraph>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_CMDPLUS" id="bm_id7230140"
localize="false"/><h3 id="par_idN1057B">+</h3>
+<paragraph role="paragraph" id="par_idN1057F"><ahelp hid=".">Add a new data
field to the list box.</ahelp></paragraph>
<h2 id="par_idN10582">Field information</h2>
-<bookmark xml-lang="en-US" branch="hid/WIZARDS_HID_DLGTABLE_COLNAME"
id="bm_id1665089" localize="false"/><h3 id="par_idN10586">Field name</h3>
-<paragraph role="paragraph" id="par_idN1058A" xml-lang="en-US"><ahelp
hid=".">Displays the name of the selected data field. If you want, you can
enter a new name.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_TYPE"
id="bm_id1665090" localize="false"/>
+<bookmark branch="hid/WIZARDS_HID_DLGTABLE_COLNAME" id="bm_id1665089"
localize="false"/><h3 id="par_idN10586">Field name</h3>
+<paragraph role="paragraph" id="par_idN1058A"><ahelp hid=".">Displays the name
of the selected data field. If you want, you can enter a new
name.</ahelp></paragraph>
+
<h3 id="par_idN1058D">Field type</h3>
-<paragraph role="paragraph" id="par_idN10591" xml-lang="en-US"><ahelp
hid=".">Select a field type.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_AUTOINCREMENT"
id="bm_id1055330" localize="false"/><h3 id="hd_id5486922">AutoValue</h3>
-<paragraph role="paragraph" id="par_id4198736" xml-lang="en-US"><ahelp
hid=".">If set to Yes, the values for this data field are generated by the
database engine.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_REQUIRED"
id="bm_id3498336" localize="false"/><h3 id="par_idN106A0">Entry required</h3>
-<paragraph role="paragraph" id="par_idN106A6" xml-lang="en-US"><ahelp
hid=".">If set to Yes, this field must not be empty.</ahelp><comment>not in
spec doc</comment></paragraph>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_LEN"
id="bm_id3498337" localize="false"/>
+<paragraph role="paragraph" id="par_idN10591"><ahelp hid=".">Select a field
type.</ahelp></paragraph>
+<bookmark branch="hid/DBACCESS_HID_TAB_ENT_AUTOINCREMENT" id="bm_id1055330"
localize="false"/><h3 id="hd_id5486922">AutoValue</h3>
+<paragraph role="paragraph" id="par_id4198736"><ahelp hid=".">If set to Yes,
the values for this data field are generated by the database
engine.</ahelp></paragraph>
+<bookmark branch="hid/DBACCESS_HID_TAB_ENT_REQUIRED" id="bm_id3498336"
localize="false"/><h3 id="par_idN106A0">Entry required</h3>
+<paragraph role="paragraph" id="par_idN106A6"><ahelp hid=".">If set to Yes,
this field must not be empty.</ahelp><comment>not in spec
doc</comment></paragraph>
+
<h3 id="par_idN10594">Length</h3>
-<paragraph role="paragraph" id="par_idN10598" xml-lang="en-US"><ahelp
hid=".">Specifies the number of characters for the data
field.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_SCALE"
id="bm_id3498338" localize="false"/>
+<paragraph role="paragraph" id="par_idN10598"><ahelp hid=".">Specifies the
number of characters for the data field.</ahelp></paragraph>
+
<h3 id="par_idN1059B">Decimal places</h3>
-<paragraph role="paragraph" id="par_idN1059F" xml-lang="en-US"><ahelp
hid=".">Specifies the number of decimal places for the data field. This option
is only available for numerical or decimal data fields.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_BOOL_DEFAULT"
id="bm_id3498339" localize="false"/>
+<paragraph role="paragraph" id="par_idN1059F"><ahelp hid=".">Specifies the
number of decimal places for the data field. This option is only available for
numerical or decimal data fields.</ahelp></paragraph>
+
<h3 id="par_idN105A2">Default value</h3>
-<paragraph role="paragraph" id="par_idN105A6" xml-lang="en-US"><ahelp
hid=".">Specifies the default value for a Yes/No field.</ahelp></paragraph>
-<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_AUTOINCREMENTVALUE"
id="bm_id8732871.00000001" localize="false"/><h3
id="par_idN10730">Auto-increment statement</h3>
-<paragraph role="paragraph" id="par_id6706747" 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_id8946501" xml-lang="en-US">CREATE TABLE
"table1" ("id" INTEGER AUTO_INCREMENT)</paragraph>
-<paragraph role="paragraph" id="par_id4846949" xml-lang="en-US">For this
example, you must enter AUTO_INCREMENT into the Auto-increment statement
box.</paragraph>
-<paragraph role="paragraph" id="par_idN105A9" xml-lang="en-US"><link
href="text/sdatabase/tablewizard03.xhp">Table Wizard - Set primary
key</link></paragraph>
+<paragraph role="paragraph" id="par_idN105A6"><ahelp hid=".">Specifies the
default value for a Yes/No field.</ahelp></paragraph>
+<bookmark branch="hid/DBACCESS_HID_TAB_AUTOINCREMENTVALUE"
id="bm_id8732871.00000001" localize="false"/><h3
id="par_idN10730">Auto-increment statement</h3>
+<paragraph role="paragraph" id="par_id6706747"><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_id8946501">CREATE TABLE "table1" ("id" INTEGER
AUTO_INCREMENT)</paragraph>
+<paragraph role="paragraph" id="par_id4846949">For this example, you must
enter AUTO_INCREMENT into the Auto-increment statement box.</paragraph>
+<paragraph role="paragraph" id="par_idN105A9"><link
href="text/sdatabase/tablewizard03.xhp">Table Wizard - Set primary
key</link></paragraph>
</body>
</helpdocument>
