How to use script to change the content of code in effect

[fy1997]

Does anyone knows how to change the code in effect by using script?

[qwerty]

I guess you mean the language: EAElement.GenType

q.

[Geert Bellekens]

I think he means the code you can type in the field Effect on an Action.

This is actually stored in t_xref with
Name = CustomProperties
Description = @PROP=@NAME=effect@ENDNAME;@TYPE=String@ENDTYPE;@VALU=Code in the effect field@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;

You might be able to read the field using EA.Element.CustomProperties, but I believe you'll have to update the database directly in order to edit it.
You can use the unsupported and undocumented method Repository.Execute to execute update or insert statements on the database. (at your own risk)

Geert

[fy1997]

I think he means the code you can type in the field Effect on an Action.

This is actually stored in t_xref with
Name = CustomProperties
Description = @PROP=@NAME=effect@ENDNAME;@TYPE=String@ENDTYPE;@VALU=Code in the effect field@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;

You might be able to read the field using EA.Element.CustomProperties, but I believe you'll have to update the database directly in order to edit it.
You can use the unsupported and undocumented method Repository.Execute to execute update or insert statements on the database. (at your own risk)

Geert

I have no idea how to do it,can you give me a example?Thanks a lot!

[Geert Bellekens]

That would be something like

Code: [Select]

Repository.Execute "update x from t_xref x set x.description = '@PROP=@NAME=effect@ENDNAME;@TYPE=String@ENDTYPE;@VALU=the new code@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;' where x.Name = 'CustomProperties' and x.Client = '" & myElement.ElementGUID & "'"
Geert

[fy1997]

That would be something like

Code: [Select]

Repository.Execute "update x from t_xref x set x.description = '@PROP=@NAME=effect@ENDNAME;@TYPE=String@ENDTYPE;@VALU=the new code@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;' where x.Name = 'CustomProperties' and x.Client = '" & myElement.ElementGUID & "'"
Geert

My problem is solved，thanks a lot!

[fy1997]

That would be something like

Code: [Select]

Repository.Execute "update x from t_xref x set x.description = '@PROP=@NAME=effect@ENDNAME;@TYPE=String@ENDTYPE;@VALU=the new code@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;' where x.Name = 'CustomProperties' and x.Client = '" & myElement.ElementGUID & "'"
Geert

I'm sorry to bother you again, but I have another question. When I want to change the guard of the connector line with script, what should I do?

[Geert Bellekens]

I'm not sure, but I think you'll have to use

EA.Connector.TransitionGuard

You can find the documentation here: https://www.sparxsystems.com/enterprise_architect_user_guide/15.1/automation/connector2_2.html

Geert