Support for identity column – PB Docs 2022

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.

You can directly add auto incremental columns for Oracle tables
in the IDE database painter, by setting the data type of the columns
to either NUMBER IDENTITY or FLOAT IDENTITY. The clause would
be: