Question Yuval Golan · Feb 8, 2023 $zcvt("abc/def","O","JSON")="abc/def" -> Why? Checked on Cache 2018.1.7 and IRIS 2022.2 write $zconvert("abc/def","O","JSON") "abc/def" Why isn't it "abc\/def" ? #Caché #InterSystems IRIS 0 2 0 202
Question Yuval Golan · Apr 23, 2018 I can insert a new record through the SMP but not through code Hi, The following sql statement is working through the SMP but couldn't make it work through the code. The table is a linked table to oracle db. Tried to change the date property in the linked table class from %Date to %String and also tried using %SQL.Statement and %Library.ResultSet this work through SMP: INSERT INTO PACKAGE.SOME_TABLE_NAME (EFFECTIVE_START_DATE,MORE,DATA,HERE) VALUES (to_date ('2018-04-01','yyyy-mm-dd'),123,456,789) In the code i'm using '?' in the statement for the parameters. #Caché #SQL 0 14 0 426
Question Yuval Golan · Jan 17, 2018 How to set at the client remote server an https web server? I have a cache client with a list of several servers.One of the server is working with an IIS server that is not the Cache DB server.The connection to the IIS server is only through https (SSL)I tried to define the Web Server IP Address to https://some.server.name but it didn't let me to specify the httpsSo I tried to define Web Server Port to 443 but when I chose the SMP it's trying to open http://some.server.name:443/csp/sys/UtilHome.csp #Caché #Management Portal 1 10 0 1.7K