Description


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



Importance



Type


Database Drivers

Operating System


Not Applicable

Status


Open

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