/text/shared/explorer/database/dabaadvpropgen.xhp Advanced Properties dialog Generated values tab page dedr: reviewed

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();