summaryrefslogtreecommitdiff
path: root/source
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2024-09-12 08:42:24 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2024-09-12 14:59:46 +0200
commitec63fc11d91d92f31fd7aca15820fafd84d2c957 (patch)
treef775a1096b43d0a3e2324ee48359ba01b657ec8c /source
parent4a1a76e6b7c74f0903b7695f137160e4c7e622f7 (diff)
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.hallot@libreoffice.org> Tested-by: Jenkins
Diffstat (limited to 'source')
-rw-r--r--source/text/sdatabase/05030300.xhp5
-rw-r--r--source/text/sdatabase/tablewizard02.xhp54
2 files changed, 31 insertions, 28 deletions
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>
generated by cgit (git 2.34.1) at 2025-03-09 18:42:30 +0000