SQL Update in a C# addin

[Guillaume]

Hi
I started writing a small C# add'in involving executing a number of SELECT SQL queries, and ending with an UPDATE SQL query.
The Update query fails so I'm wondering if EA prevents from doing this.

Update is run on the t_packages table

Thanks
Guillaume

[Geert Bellekens]

Guillaume,

Repository.SQLQuery only allows read-only queries.
For other types of SQL commands use Repository.Execute().

Geert

[Guillaume]

Thanks Geert, I'll try that.