I am having a problem populating an ID attribute "GISOBJID" which is a string in a versioned SDE data set. The AUTONUMBER I want to combine "ASSETNUM" works fine for everything , but I want to combine that with an ALPHA prefix (FM-123) into the "GISOBJID" attribute. I have tried several ways and no success. Only the AUTONUMBER works. I have tried using the full SDE name "UTILITIES2.CCU.ssPressurizedMain" in the DynamicValue Table and the shortened version "ssPressurizedMain" with no results. I have also tried an EXPRESSION "FM-" & Str( [ASSETNUM] ) and GenerateID with SSPRESSURIZEDMAIN|0|FM-[seq] still no success. Any help with this would be greatly appreciated. Thanks in advance!
1.
2.
3.
I know this is possible using GENERATEID, because I did the EXACT same thing you are trying to do.... but I'm using a SQL SP for my asset id assignment now, so I don't have the method in my dynamic value table anymore! Let me try to rack my brain. The field type of your GISOBJID field is text right?
Thanks for the reply Cort. Yes the GISOBJID is a text value. Neither of the DynamicValue or GenerateID tables are versioned and they reside in the SDE dataset. I've been racking my brain trying combinations with no success.