go to post Robert Cemper · Nov 28, 2021 this is the method description it seems that you should your call parameters differently method ExecuteProcedure(ByRef pResultSnapshots As %ListOfObjects, Output pOutputParms As %ListOfDataTypes, pQueryStatement As %String, pIO As %String, pInputParms...) as %Status [ Language = objectscript ] The pOutputParms list returns the output values of all scalar output and input/output parameters.This would result in this order SET tSC = ..Adapter.ExecuteProcedure( , .outparm, SQLQuery2 , "io*", pRequest.StringValue ) >> 1st par - skipped>> 2nd par = output byRef>> 3rd par = SqlQuery>> 4th par = io>>par 5 ... query input parameters This explains the log
go to post Robert Cemper · Nov 28, 2021 pass outparm by reference .outparm SET tSC = ..Adapter.ExecuteProcedure(,,SQLQuery2,"io*",pRequest.StringValue,.outparm )
go to post Robert Cemper · Nov 28, 2021 intersystemsdc/irishealth-community:2021.1.0.215.3-zpm should do itor simply the latest docker run --name my-iris -d -p 9091:1972 -p 9092:52773 intersystemsdc/irishealth-community
go to post Robert Cemper · Nov 26, 2021 BINGO! that''s the way to go. I typically use from Terminal >SET ^GO=0 and in code SET ^JOB($h)=$JOB FOR x=1:0 HANG 1 IF $GET(^GO) QUIT and of course Studio to attachor I use $system.CSP.Shell() as described here
go to post Robert Cemper · Nov 26, 2021 as official documentation tells you:https://docs.intersystems.com/iris20211/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_langelements#GSQL_langelements_ops_precedence USER>SET status=$SYSTEM.SQL.Util.SetOption("ANSIPrecedence",1,.oldval) USER>do $system.SQL.Shell() SQL Command Line Shell --------------------------------------------------- [SQL]USER>>SELECT 1+2*3+4*5 1. SELECT 1+2*3+4*5 Expression_1 27 ^^^^----------------------------------------------- [SQL]USER>>q USER>SET status=$SYSTEM.SQL.Util.SetOption("ANSIPrecedence",0,.oldval) USER>do $system.SQL.Shell() SQL Command Line Shell --------------------------------------------------- [SQL]USER>>SELECT 1+2*3+4*5 3. SELECT 1+2*3+4*5 Expression_1 65 ^^^^---------------------------------------------- [SQL]USER>> .
go to post Robert Cemper · Nov 26, 2021 Even the possibility of changing this elementary rule after 60+yearshas the power and the risk of breaking millions of lines of code worldwide.It's for people like you that are not willing to accept these rules thatthe introduction of Embedded Python is encouraged. With the same mindset,you may demand to revert from Italian, French Spanish, Portugueseto pure Latin as spoken by Cesar. Or for French to Occitan ?
go to post Robert Cemper · Nov 26, 2021 Forget about the week and put your long query into a subselect SELECT Sum(Dicos),Sum(Gen),Sum(Philo),Sum(Religion), Sum(SHS), .... FROM ( .... your long query )
go to post Robert Cemper · Nov 24, 2021 Just another strong argument for embedded PythonOr calling Py over $ZF() or CPIPE for older versions The code to convert XML to JSON is quite simple, just two lines.The xmltodict. parse() method will convert the XML to a python objectthat can then be converted to JSON. How to convert XML to JSON in Python – Step by Step guide(found by Google)
go to post Robert Cemper · Nov 23, 2021 I have not heard of that but it could be a good reason to use an existing solution based on Python or C++ or other as offered herehttps://developer.ibm.com/apis/catalog/aspera--fasp-manager-sdk/downloads/downloads.json
go to post Robert Cemper · Nov 23, 2021 the example breaks on Win and in Docker with <DIVIDE>. PullRequest for fix is pending
go to post Robert Cemper · Nov 22, 2021 Of course! Browser Caching could be a beast.I remember CSP or ZEN testing when I couldn't get rid of the old cached image version
go to post Robert Cemper · Nov 21, 2021 a typical feature of DNS resolution is caching of the translationsof servername.domain.name.tld or servername to IP addr.so the resolution is just done once.And a clever DNS would detect "oh it's me"
go to post Robert Cemper · Nov 21, 2021 in Open Exchange you find 15 examples searching for Angulare.g.angular-material-iris-starter, iris-sample-rest-angular, ....13 others
go to post Robert Cemper · Nov 19, 2021 hmmm 4 hours is a lot.What's the DB you insert it ? If external, jdbc / odbc ?
go to post Robert Cemper · Nov 18, 2021 it is possible, but I'd rate it as highly inefficient. You have been warned.working for objects and SQL /// The company this employee works for. Relationship Company As Company [ Cardinality = one, Inverse = Employees ]; Property Cname As %String [ Calculated, SqlComputeCode = {set {*}=##class(Company).%OpenId({Company}).Name }, SqlComputed ];
go to post Robert Cemper · Nov 18, 2021 what's the location to work ???? 611 N. Iron Bridge WaySpokane, WA 99202???
go to post Robert Cemper · Nov 16, 2021 It was an additional pleasure to see your verbose comments in dock-compose.yml.not just the usual plain parameters with no explanation of what the intention is!