go to post Enrico Parisi · Feb 1, 2020 Hi Timothy, very nice article, I think that regarding restoring of the current device: Set $io = tDevice The proper way to set the current device ($io) is issuing the Use command: Use tDevice From the doc: You issue a USE command to change the current device...... This special variable cannot be modified using the SET command. Attempting to do so results in a <SYNTAX> error. https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?K... Enrico
go to post Enrico Parisi · Jan 28, 2020 I think you mistyped, the condition should be: PostCodeLastCharacter(HL7.{PID:11(1).5})=1 Enrico
go to post Enrico Parisi · Jan 28, 2020 Hi Martin, whenever you have a "special need" (not saying that $e() is special...but..) in rules or DTL, you can create a Custom Utility Function, see: https://cedocs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?K... Get back if any problem arise writing the function. HTH Enrico
go to post Enrico Parisi · Jan 6, 2020 Sorry, last line should be:SAMPLES>If '$data(rsmd.columnIndex("NOTEXISTENT")) Write "" Enrico
go to post Enrico Parisi · Jan 6, 2020 I think the most efficient way to test if a column exists in the result set is using the columnIndex property of the metadata (instance of %SQL.StatementMetadata): SAMPLES>Set rs=##class(%SQL.Statement).%ExecDirect(.st,"select name,age from Sample.Person")SAMPLES>Write rs.%Next()1SAMPLES>Set rsmd = rs.%GetMetadata()SAMPLES>If $data(rsmd.columnIndex("NAME")) Write rs.NameXiang,Gertrude X.SAMPLES>If $data(rsmd.columnIndex("NOTEXISTENT")) Write "" Enrico
go to post Enrico Parisi · Aug 4, 2017 If you are already familiar with BouncyCastle in C# probably the easiest way for you is to use the Java Gateway or the .NET gateway to call out the Java or C# BouncyCastle library.In either case, I'd suggest to write a little or some little (i.e. limited to your needs) wrapper that you then call from COS.HTHEnrico