Posts:
Replies:
Jean Millette · Apr 25
Jean Millette · Apr 22
You're welcome Andy
Jean Millette · Apr 22
When does "tSC" get defined? This line might be the problem, causing the for loop to stop:
If $$$ISERR(tSC) Quit
(Comment out that line and watch the results appear :-))
Followers:
Following:
Jean has not followed anybody yet.
Global Masters badges:







Please check out this documentation, where there is an example of using an array holding the sql statement:
%SQL.Statement - InterSystems IRIS Data Platform 2021.2 - including private class members
According to that document, the query your code builds and passes to %Prepare is "UPDATE QUERY UPDATE QUERY", which is not valid.