From ec63fc11d91d92f31fd7aca15820fafd84d2c957 Mon Sep 17 00:00:00 2001 From: Olivier Hallot Date: Thu, 12 Sep 2024 08:42:24 -0300 Subject: 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 Tested-by: Jenkins --- source/text/sdatabase/05030300.xhp | 5 ++- source/text/sdatabase/tablewizard02.xhp | 54 ++++++++++++++++----------------- 2 files changed, 31 insertions(+), 28 deletions(-) (limited to 'source') 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 @@ + +

Type formatting

In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The Type formatting dialog is the third window of the Copy table dialog.

List box

Field list

Lists the data fields that will be included in to the copied table.

Column information

Field name

Displays the name of the selected data field. If you want, you can enter a new name. 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 @@ -Table Wizard - Set Types and Formats +Table Wizard - Set Types and Formats /text/sdatabase/tablewizard02.xhp

Table Wizard - Set Types and Formats

-Specifies the field information for your selected fields. +Specifies the field information for your selected fields.

Selected fields

-Select a field in order to edit the field information. +

Selected fields

+Select a field in order to edit the field information.

−

-Remove the selected field from the list box. -

+

-Add a new data field to the list box. +

−

+Remove the selected field from the list box. +

+

+Add a new data field to the list box.

Field information

Field name

-Displays the name of the selected data field. If you want, you can enter a new name. - +

Field name

+Displays the name of the selected data field. If you want, you can enter a new name. +

Field type

-Select a field type. -

AutoValue

-If set to Yes, the values for this data field are generated by the database engine. -

Entry required

-If set to Yes, this field must not be empty.not in spec doc - +Select a field type. +

AutoValue

+If set to Yes, the values for this data field are generated by the database engine. +

Entry required

+If set to Yes, this field must not be empty.not in spec doc +

Length

-Specifies the number of characters for the data field. - +Specifies the number of characters for the data field. +

Decimal places

-Specifies the number of decimal places for the data field. This option is only available for numerical or decimal data fields. - +Specifies the number of decimal places for the data field. This option is only available for numerical or decimal data fields. +

Default value

-Specifies the default value for a Yes/No field. -

Auto-increment statement

-Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field. For example, the following MySQL statement used the AUTO_INCREMENT statement to increase the "id" field each time the statement creates a data field: -CREATE TABLE "table1" ("id" INTEGER AUTO_INCREMENT) -For this example, you must enter AUTO_INCREMENT into the Auto-increment statement box. -Table Wizard - Set primary key +Specifies the default value for a Yes/No field. +

Auto-increment statement

+Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field. For example, the following MySQL statement used the AUTO_INCREMENT statement to increase the "id" field each time the statement creates a data field: +CREATE TABLE "table1" ("id" INTEGER AUTO_INCREMENT) +For this example, you must enter AUTO_INCREMENT into the Auto-increment statement box. +Table Wizard - Set primary key -- cgit