How to make all existing ClassMethods and Queries "SqlProc" within tables
Hi,
We have a large number of tables with an even larger number of Queries and Class Methods within them and we wish to add the SqlProc keyword to all of them.
Does anyone know if there is a simple way to do this other than by pasting [ SqlProc ] to each method/query? i.e. placing a keyword at the class level rather than a method/query level.
Product version: IRIS 2022.1
I don't think you can add SqlProc at class level, but you can modify the class definition programmatically.
Look at the class %Dictionary.MethodDefinition and the property SqlProc, if you set it to 1 is the same as adding [SqlProc] to the method.
%Dictionary.MethodDefinition is a child class of %Dictionary.ClassDefinition.
Of course I advise you to test it in a temporary system/namespace before...
Hope it helps,
Enrico
Or you can just change the files in VSCode using Find and Replace with some wise regular expression
Thank you both :-)