I have a valid GUID string that I need to use as the default value for a field on a particular table - this field acts as a foreign key. According to the documentation for AssignDefaultToField_management, the default value argument must match the data type of the field.
I figured that it would be as simple as casting the string into a GUID, like:
But doing so results in a generic "Object: Error in executing tool" message. I assume that the problem is that the uuid data type in Python isn't actually the same as what's used by ESRI but I can't find any documentation on what that data type is, much less how to cast a string to it. Anyone have any pointers?
I've also tried adding in brackets around the uuid, formatting it like so:
Neither of these worked.
Perhaps this tech support article will help: How To: Calculate unique identifier values similar to Global IDs
I don't think a field using a GUID can have a default value set. An alternative would be to create/use a text field.