Executing SQL update

[novikovigor]

I can execute SQL select with "Model Search" tool.
But how can I execute update and insert commands in EA? Is there fast way to do it?

[Geert Bellekens]

You can't with the model search.

If you are working with a .eap file you can open that in MS Access to execute update queries, or just use any other generic SQL client.

If you are working on a dbms repository you best use the client for that type of database.

You could also write a script or add-in and use the "hidden" operation Repository.Execute(SQLString) to execute your update queries.

Just be really really careful. It's quite easy to completely destroy your model using SQL

Geert

[novikovigor]

Thank you, Geert! I'll use MS Access.