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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.