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
