From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- helpcontent2/source/text/sdatabase/11020000.xhp | 68 +++++++++++++++++++++++++ 1 file changed, 68 insertions(+) create mode 100644 helpcontent2/source/text/sdatabase/11020000.xhp (limited to 'helpcontent2/source/text/sdatabase/11020000.xhp') diff --git a/helpcontent2/source/text/sdatabase/11020000.xhp b/helpcontent2/source/text/sdatabase/11020000.xhp new file mode 100644 index 000000000..8e1f9484b --- /dev/null +++ b/helpcontent2/source/text/sdatabase/11020000.xhp @@ -0,0 +1,68 @@ + + + + + +ODBC +/text/sdatabase/11020000.xhp + + + +
+

ODBCstill some Help IDs in this file. Else it can be removed

+Specifies the settings for ODBC databases. This includes your user access data, driver settings, and font definitions. +
+
+

User Name

+Type the user name for accessing the database. +
+
+

Password required

+Prevents an unauthorized user from accessing the database. You only need to enter the password once per session. +
+
+

Driver Settings

+Use this text field to enter additional optional driver settings if this is necessary. +
+
+

Character Set

+Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database. Choose "System" to use the default character set of your operating system. Text and dBASE databases are restricted to character sets with a fixed-size character length, where all characters are encoded with the same number of bytes. +
+
+

General

+

Retrieve generated values

+Enables $[officename] support of auto-incremented data fields for the current ODBC or JDBC data source. Select this check box if the database does not support the auto-increment feature in its SDBCX layer. In general, the auto-increment is selected for the primary key field. +

Auto-increment statement

+Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field. For example, a typical SQL statement to create a data field is: +CREATE TABLE "table1" ("id" INTEGER) +To auto-increment the "id" data field in a MySQL database, change the statement to: +CREATE TABLE "table1" ("id" INTEGER AUTO_INCREMENT) +In other words, enter AUTO_INCREMENT into Auto-increment statement box. +

Query of generated values

+Enter an SQL statement that returns the last auto-incremented value for the primary key data field. For example: +SELECT LAST_INSERT_D(); +
+
+

Use SQL92 naming constraints

+Only allows names that use characters that conform to the SQL92 naming constraints in the data source. All other characters are rejected. Each name must begin with a lower or upper case letter, or an underline ( _ ). The remaining characters can be ASCII letters, underlines, and numbers. +
+

Use Catalog for file-based databases

+Uses the current data source of the Catalog. This is useful when the ODBC data source is a database server. If the ODBC data source is a dBASE driver, leave this check box clear. + + -- cgit v1.2.3