Skip to main content
  • EN

I can set an index on an integer or even a unique index, but there is no type for a primary key or autoincrement. How can I specify this? I could do this with an SQL Create expression. Can I use SQL to create a schema?

I am adding a changeset with new records using insert but I need an OID column for ArcGIS to be able to use the table/featureclass separate from the real ID.

My workaround is to post process use the 'SQL to Run After Write' :

UPDATE changeset SET OID = rowid where OID is NULL

Not quite a proper autoincrement, but it gets around the current roadblock.

I think this can be dine in the User Attributes tab in the (Feature)Writer. Set type to integer and Index to Unique.

2023-05-10_13h07_22

Reply


Community Stats

30,351
Posts
115,342
Replies
38,083
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.