automatic sequential numbering when creating objects

JoeGerner

I have an ArcSDE with several tables. I want to create a new field in each table. This field should be filled automatically when the object is created. The field should contain a six-digit sequential number, i.e., 000001 for the first object, 000002 for the second object, and so on.

I have already tried using the tool enerate database sequence and arcade in the attribute rules, but I cannot achieve the desired result.

Arcade Code

var v = NextSequenceValue($datastore, "SEQ_KNR");
return Text(v, "000000");

I use ArcGIS Pro 3.3

danielri

 

My first question is why do you want the field to be TEXT in the database, could you not have it be an INT then just convert it in code when needed? Secondly, you did not say the database type, but if it is in SQL or SQLite you can add an autoincrement field to the table.

Copy code

CREATE TABLE users (
    my_new_id INTEGER PRIMARY KEY AUTOINCREMENT,
    username TEXT NOT NULL,
    email TEXT NOT NULL
);

• Auto-increment fields cannot be updated manually unless explicitly allowed.
• If you delete rows, the auto-increment counter does not reset unless you manually reset it.
• Use BIGINT instead of INT if you expect very large numbers.
• you can set a 'start' number for the sequence as well.
• an autoincrement field DOES NOT have to be a primary key (or a key at all)