Good evening all,
We are actually facing some difficulties to put an SQL query inside a Tag change Script.
We are actually having an error message looking like :
.......", line 7, in valueChanged at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:364) at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepQuery(AbstractDBUtilities.java:290) at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepQuery(select * from HISTORY, , [null], .>
When we put the query in a simple button for example or in the Scrpting console, it works perfectly, but on the tag change script, it never works. Did we missed something ?
King regards,
Yassine