Set RefGUID tagged value to <none> in add-in

[McMannus]

Hi all,

I have a stereotyped profile element having a RefGUID tagged value by design. The shapescript of the element shows the referenced element name if the tag has a value.
At some point in time I am clearing all instances of that tagged value in the model by

Code: [Select]

UPDATE t_objectproperties SET [Value]=' ' WHERE Property='MyTVName'Note that the value of [Value] is not allowed to have a zero length, so I had to include a space. If this is done like that shapescript interprets that as definition.
When I select <none> in the tagged values window manually (press ellipsis to the type selection dialog -> select none) the shapescript interprets it correctly.

Q: How does EA store the <none> selection in the value of field of the tag? Is there something like null in SQL? I'd like to immitate the EA behavior.

[McMannus]

OK guys,

I answered my question on my own. The correct query to accomplish what I need is

Code: [Select]

UPDATE t_objectproperties SET [Value]=NULL WHERE Property='MyTVName'