Question Jerry Petrole · Nov 15, 2023 SMS Texting solutions I'm looking for an SMS Texting solution that will implement easily with IRIS. Our company uses Twilio for our .Net applications but I'm hoping there might be something else available. If anyone has experience with this please let me know! Best, Jerry #InterSystems IRIS 1 4 1 218
Question Jerry Petrole · Jan 14, 2022 Sending files with %Net.FtpSession Hello, Does anyone have experience sending files using %Net.FtpSession? I am not seeing any methods in the class for sending files and setting up an Ensemble production is not an option. Any advice would be appreciated. Thank you. #InterSystems IRIS 0 6 0 292
Question Jerry Petrole · Mar 22, 2021 Unknown error thrown with large file conversion to dynamic object. Hello I am creating an import tool to convert a client's JSON data into IRIS classes. The sample file is over half a gig. I am copying the data into an instance of %Stream.FileCharacter;. My first few attempts worked fine. However I started getting an error thrown when I try to create a DynamicAbstractObject using the %FromJSON method. See the code below. The error code given is not in the documentation, at least not the doc that I was searching. #JSON #InterSystems IRIS 0 3 0 329
Question Jerry Petrole · Feb 5, 2021 ODBC Connection - Receiving SQL Errors Hello, I have established an ODBC connection with our client based on credentials they provided. The test connection was successful and after using the Link Table wizard I can now see the client's tables and properties. However when we try to execute a query in IRIS we are getting error code -226. I'm trying to determine if this could be just a simple setting problem in IRIS or something with the client. We have tried with PostgreSQL as well as with TSQL. Same result for each. #ODBC #SQL #InterSystems IRIS 0 3 0 331
Question Jerry Petrole · Sep 5, 2019 SQL result set stepped on when calling to another method Hi all,We just encountered an instance of a result set RS and while looping through the results, RS is getting overwritten when method 1 calls out to method 2 (in the same class). Method 2 creates it own result set also named RS. This code is several years old and never had this problem. When I changed the name of the result set variable in method 1 the problem cleared up. I though that variables were automatically 'newed' in classmethods. ??? #Caché 0 4 0 192
Question Jerry Petrole · Jul 17, 2019 Allowing piecemeal access to System Operation functions Hello,Does anyone know if it's possible to allow a user type access to only certain parts of the System Operations page? Specifically, the System Logs - Application Error Logs.Thanks much!Jerry #System Administration #Caché 0 2 0 224