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 --- .../source/text/sdatabase/dabaadvpropgen.xhp | 52 ++++++++++++++++++++++ 1 file changed, 52 insertions(+) create mode 100644 helpcontent2/source/text/sdatabase/dabaadvpropgen.xhp (limited to 'helpcontent2/source/text/sdatabase/dabaadvpropgen.xhp') diff --git a/helpcontent2/source/text/sdatabase/dabaadvpropgen.xhp b/helpcontent2/source/text/sdatabase/dabaadvpropgen.xhp new file mode 100644 index 000000000..d9312dc5e --- /dev/null +++ b/helpcontent2/source/text/sdatabase/dabaadvpropgen.xhp @@ -0,0 +1,52 @@ + + + + + +Generated Values +/text/sdatabase/dabaadvpropgen.xhp + + +Advanced Properties dialog Generated values tab page + + + + + database advanced properties;autoincrement values + database advanced properties;automatic generated values + database advanced properties;retrieve generated values + database advanced properties;query generated values + +
+

Generated Values

+Specifies the options for automatically generated values for new data records.UFI: all text copied from shared\explorer\database\11020000.xhp +
+how to get this: Edit Database AdvancedProp ??? I have no idea +The availability of the following controls depends on the type of database: +

Retrieve generated values

+Enables $[officename] support for auto-incremented data fields in the current ODBC or JDBC data source. Select this option if the auto-increment feature in the SDBCX layer of the database is not supported. In generalUFI: this does not mean that something is set by default, but "normally,", 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, 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. +

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(); + + -- cgit v1.2.3