EA Scripting problem with auto name counter.

[asseco]

Hi.
I tried to update auto name counter for diagram from within JScript script. I have configured EA > Settings > Auto name counter .. > Type: Dgm-Logical. It store data inside t_trxtypes table;  

I get counter data ( number ) from this xml variable:

xml = Repository.SQLQuery('select notes from t_trxtypes where description = \'Autocount\' and trx = \'Dgm-Logical\';');      


Repository.SQLQuery method can only select data. I tried update data like below but it not work.

counter = Repository.SQLQuery('update t_trxtypes set notes =\''+data+'\' where description = \'Autocount\' and trx = \'Dgm-Logical\'; commit;');

Is any other way to get/change or update actual counter value within JScript?

[Geert Bellekens]

Use Repository.Execute(SQLUpdateString)

Geert

[asseco]

Thx. Its working.