Automation

[Maggie]

Hi
Does anyone know if it is possible to set properties on an object that no interface exists for?
For example I can set an object's status field (element.status)
but not something like concurrency or cardinality.
How would I do something like that

Thanks

Magie

[Helmut Ortmann]

Hi,

if something isn't part of API you can use code like:

Code: [Select]

string updateStr = @"update t_object set classifier_GUID = '" + method.MethodGUID +
                   "' where ea_guid = '" + action.ElementGUID + "' ";
rep.Execute(updateStr);

Of course:Be careful and test it with non productive data.

There are two books from Thomas Kilian which might help you:

• InsideEA
• ScriptingEA

Helmut

[Maggie]

Thanks Helmut

Im pretty new to all this.
Please could explain what your code is doing and how I would run it

Thanks

Maggie

[qwerty]

Helmut's example is actually some C-dialect excerpt and it manipulates the table which holds the properties (visible and invisible) for all EA elements. So basically if you want to change those invisible things you might need to update the table directly using some script or add-in.

q.

[Helmut Ortmann]

Hi Maggi,

the code is part of a C# Addin and it writes to the repository by means of SQL (Structured Query Language).

The first line simply sets a variable with the SQL update Code.
The second line makes an undocumented EA API call to run the update to the repositoy.

If you are interested in Addin go to the community and search for Geerts Tutorial (First Addin in 10 Minutes).

With Addins you can do almost everything. Things not part of the API you can solve by SQL as described above.

Helmut