Repository.Execute no longer works in JScript

[Mauricio Moya (Arquesoft)]

While testing the latest version of EA (17.2 build 1721), I noticed that JScripts that were working perfectly in previous versions are now failing on lines containing Repository.Execute("insert SQL here"). I am now getting an "Internal Error" when the script reaches that line.

Does anyone know if this command has been deprecated? Has it been replaced by something else?

[Geert Bellekens]

I'm guessing this is one of the "security" fixes, but I'm pretty worried about that myself.

There are quite some things that are not possible in the API without resorting to the Repository.Execute backdoor method.
If this method is indeed no longer available, that would break quite a few of my add-ins and scripts.

Geert

[philchudley]

I agree Geert, there's a lot of scripts I have developed for clients and myself which are going to break if they upgrade to EA v 17.2

Not good 

Phil

[Geert Bellekens]

I've sent an email to support about this one, and the restrictions on Repository.SQLQuery (where you can't select from certain tables anymore, e.g. t_seclocks)

Hoping for an alternative

If they can't provide an alternative solution, I'm guessing I'll have to resort to a direct database connection to execute these type of queries/updates.
The upside of that would be that it would be a lot faster then going through Repository.SQLQuery
Obvious downside if that you have to manage your own database connection.

Geert