SQL object update

[Alexander.Golyshkin]

How is possible update a note value or other EA object using SQL query. I have tried below query, but looks like it makes  nothing

Code: [Select]

UPDATE t_object SET t_object.Note = 'TEST_NEW' WHERE t_object.Object_ID = 17574

[Eve]

If you're talking about Repository.SQLQuery or any place in the UI that allows execution of SQL, EA will not run that statement. We strongly discourage / don't support any modification of the model via direct SQL.

[Geert Bellekens]

The best option is to write a script that might use an SQL Query to get the the relevant elements, and then use the supported API to update the elements.

Geert

[Alexander.Golyshkin]

Thnx. I did exactly as you wishes...

Could you also check this question? https://sparxsystems.com/forums/smf/index.php/topic,48954.msg283260.html#msg283260