Supports Identity columns in the Oracle database:
-
When a DataWindow object is created, the Identity column is automatically set (read from the database). You can modify the Identity column in the Specify Update Properties.
-
When inserting rows with an Identity column, the Identity column is excluded from the INSERT statement. Its value is generated based on the GENERATED BY DEFAULT.
-
After a new row is inserted, the value of the Identity column in the row will show after the Update.
Note: The DataWindow automatically gets the biggest value for the Identity column in the newly-added row after the Update. Therefore if the Identity column auto-increments by a negative number (which is supported by Ora Oracle and ADO.NET, but not by ODBC), the value shown for the newly-added row may be incorrect. You can execute a Retrieve on the DataWindow to get the correct value.
-
It is now supported to directly add auto incremental columns for Oracle tables in the IDE database painter: You can do it by setting the data type of the columns to either NUMBER IDENTITY or FLOAT IDENTITY. The clause would be:
GENERATED ALWAYS AS IDENTITY INCREMENT BY 1 START WITH 1
