In both SQL Server and Oracle we can create autonumber integer fields for primary keys. We use it also. But we need always to change the generated SQL Server Procs for insert and create for Oracle a sequence trigger Can Uniface implement this in the entities as a field type?

Use Case



Database Drivers

Operating System

Not Applicable



3 thoughts on “DB: autonumber”

  1. As well as what is mentioned in the linked wishlist case, you could also do something that we have done….

    (we were using Sybase Identity columns)

    Write yourself a little Uniface code or shell script to parse your Uniface generated SQL proc and add your identity column definitions in the SQL.
    You would then be able to modify your errorField triggers to handle (looking for 0129) the NULL in your PK values on STORE, and have your DB do the rest.

Leave a Reply