Question John Hotalen · Sep 17 Need help with XML to JSON format Hello to my fellow Cache Gurus: I ran into two issues with Cache to XML Export and Cache to JSON Export in regard to array sequences. So before I waste time opening a WRC ticket, I figured I would poll the Development Community, since there is always so much wonderful feedback and suggestions via this Developer Community! So much thanks in advance for everyone's input! Go Team! #JSON #XML #Caché 0 6 0 133
Question John Hotalen · Jan 23 Cache ZEN Issues with MS Edge Dear Fellow Cache Developers and Cache Experts, The company I work for has a Cache Web Application that is built on the Cache ZEN framework. The application has run very well for almost 2 decades across many versions of MS Internet Explorer ranging from IE5 all the way through IE11. #Caché 0 0 0 123
Question John Hotalen · May 25, 2022 Cache MONLBL Response Time question Hello to all my fellow Cache Experts. Quick question about the MONLBL output that identifies performance issues. There is a metric value output by MONLBL called "Obtain [NEW] connection to Cache". Supposedly that metric captures the time taken between the request reaching the CSP Gateway and a connection to Cache being reserved for the purpose of servicing the request. All of that being said, if that metric value is high for many requests, such as 19.x seconds, then can anyone tell me what that metric really means and how to improve (lower) the new connection to Cache time. The com #Caché 0 3 0 288
Question John Hotalen · Jan 26, 2022 ZEN Tablepane double click issue Hello To all my fellow Cache Developers, #Caché 0 2 0 134
Question John Hotalen · Jun 27, 2019 CSP Gateway Compatibility with Cache Versions Does anyone know if the Cache CSP Gateway version 2016.1.0 can run with both Cache 2017.1.x and Cache 2013.1.x? Thanks. #CSP #Platforms #Caché 0 1 0 502
Question John Hotalen · Jun 7, 2019 Issue with shortcuts on ZEN Page with PDF document Hello Cache Developers! The purpose for this post is to outline a coding challenge that I have encountered when trying to use shortcuts (i.e. CTRL+G) within a ZEN application. Allow me to provide a summarized background:Our application has a ZEN page (call it the PPL page) with a tablepane that displays a list of records. This page also has an iFrame (#1) #Frontend #Caché 0 1 0 261
Question John Hotalen · Jan 25, 2019 TWAIN interface to Cache Application Hello Cache Developers: I was curious if anyone has ever created a TWAIN interface to their Cache Application? I am new to TWAIN and hence the reason for this question. From what I understand, TWAIN is software used by various digital imaging software and TWAIN provides an API for applications to call to be able to import images into their application. I work with a healthcare application and was wondering what types of things are required for a Cache Web Application to call the TWAIN API to be able to load images into a Cache table. Any input, sample code, or suggestions is apprec #API #Frontend #Caché 1 4 0 636
Question John Hotalen · Jan 25, 2018 Cache - How to change Image File Size when saving to Cache Database Table Hello to all my fellow Cache Developers/Experts: My question has to do with how I would go about changing the image file size when loading (saving) an image file (i.e. JPG, BMP, GIF, PNG, etc...) to a Cache Database Table. Here is my business scenario: #Caché 0 7 0 770
Question John Hotalen · Nov 30, 2016 Persistent Classes and Transient SQL Calculated/Computed properties Hello Fellow Caché Developers,The purpose of this post is to ask for everyone's thoughts and input around the use of transient, SQLCalculated/Computed properties within persistent classes.This approach allows for extra data values needed in SQL queries to be available without having to join to other tables.Very simple/basic example to illustrate the topic:Let's say I have a persistent class named ICDAutoCodeDefn to hold ICD Auto-Coding definitions, such as: #Object Data Model #SQL #Caché 0 4 0 786
Article John Hotalen · Oct 4, 2016 1m read How to Parse a URL in Caché How to parse a URL in Caché:Let's pretend you are working on a project where you may be retrieving a URL for some purpose and you have the need to be easily able to parse apart that URL to get the various components that make up the URL.Here's how to do that: #Caché #Tips & Tricks #Frontend 2 8 0 1.8K
Article John Hotalen · Sep 29, 2016 1m read Cache - Checking If a Directory or File Exists Checking if Directory or File Exists: Outlined below is an example of how to check if a directory exists: Set directoryName="c:\temp\nosuchdir" /* Check for existence of a directory - Return Value: 0 - directory does not exist; 1 - directory does exist */ Set directoryExists=##class(%File).DirectoryExists(directoryName) If ('directoryExists) // do the processing for when a directory does not exist Outlined below is an example of how to check if a file exists: #Caché #Code Snippet #Tips & Tricks 3 1 0 3K
Article John Hotalen · Sep 29, 2016 1m read Cache Studio - How to Change the Login User The one question that some of you might have is: How do I change my login information for Cache Studio if I clicked the checkbox to automatically save my login info so I do not have to enter my username/password every time I open Studio? Well.....excellent question!!!!!!Here's the answer: #Studio #Tips & Tricks #Caché 5 1 1 1.4K
Question John Hotalen · Aug 31, 2016 Indexing - How to create an index on a List property Hello Fellow Cache Developers: Has anyone ever created an index on values of a list property? If so, would you be willing to share an example?Also, feel free to offer input and suggestions regarding use of indexes on List values.Here is my database scenario:Parent Class:PropertyA - %String PropertyB - %Integer Child Class:PropertyC - %IntegerPropertyD - list of %IntegerData illustration: #Indexing #Object Data Model #SQL #Caché 0 2 0 582