Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: novikovigor on June 21, 2013, 02:04:07 am

Title: Executing SQL update
Post by: novikovigor on June 21, 2013, 02:04:07 am

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?

Title: Re: Executing SQL update
Post by: Geert Bellekens on June 21, 2013, 04:02:35 pm

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 ;D

Geert

Title: Re: Executing SQL update
Post by: novikovigor on June 21, 2013, 08:05:47 pm

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