Question Kevin Furze · Apr 26, 2021 what's a SAFE way to let my boss connect to the Cache database (VIEW ONLY) The boss (reasonable intelligent ;-) wants to connect to the cache database through Excel, but unless I explain what he's looking for (field names DB names etc) then I can see him continually coming back for "what's the link here and how do I get the delivery company name etc etc" is there a SAFE way I can give him access to our database using an intelligent visual user interface. I had thought about the SQL Query Builder within the management portal, but the thought of giving him access to all of the other functionality of the management portal. #SQL #Caché 0 3 0 193
Question Kevin Furze · Nov 15, 2020 background processes cannot access network shares version cache for windows, 2017.2.1 build 801_3 - windows 10 I had this system set up for 3+ years now, and background tasks such as converting emails, have always worked, suddenly it's stopped working and I've tracked it down to any network references. reading the emails, I look for any attachment files, and save them to a network drive before processing them within a class method, I've been testing it by sending exactly the same email repeatedly and checking the saving of the attached file in both the background and in the terminal. #Terminal #Caché 0 11 0 310
Question Kevin Furze · Jul 31, 2020 Using the SQL Shell Interface - changing the delimiter in the outputted cache 2017.2 windows 10 Is there any way to change the sql Shell interface to output a <TAB> between the fields instead of outputting one or more spaces between columns I needed to run an sql ( that took a while to run) and then cut and paste the generated output into excel, trouble was the paste into excel was not very good for columns when there's spaces used between the columns kev #SQL #Caché 0 3 0 167
Question Kevin Furze · Jan 15, 2020 sql statements - how to clear multiple sql statements and Frozen Flags cache 2017.2.1 (Build 801_3) when I look into the "sql statements" ( sql page of the management portal ) I have lots of old statements with a lot of them frozen. many of them are %sqlcq routines (I believe these are the SLQ's I run when testing/running random SQL queries in the sql page. ) I can clearly see where I can click on an individual query and untick an individual query to unfreeze it. or delete it. but thats a painful slow process. I can't see anywhere to delete/change multiple queries #Code Snippet #SQL #Caché 0 2 0 174
Question Kevin Furze · Jan 9, 2020 pButtons does not generate the actual stats - 2017.2.1 on win64 $zv = Cache for Windows (x86-64) 2017.2.1 (Build 801_3) Thu Apr 12 2018 10:14:19 EDT I have a problem with my installation that I've logged with WRC, I've been asked (and have done so) to run ^pButtons here's what I did. #Caché 0 3 0 140
Question Kevin Furze · Aug 15, 2019 intersystems Open exchange suggestion I've just been tempted to the option exchange (curiosity) and when browsing, I often right-click, and open links in a new tab, eventually ;-) I have enough interesting open tabs to go off and read the tabbed articles,I can't do this in open exchange, it will only allow a direct click to open the url.even worse, when I come back (to where I left off) It starts from the top of the page.any chance of changing the url's to allow us to right click and open in a new tab #Open Exchange 2 3 0 168
Question Kevin Furze · Jan 16, 2019 storage of usernames, passwords in plain Cache systems 2017.2 version I need to automate the handling of usernames passwords, serverNames etc for use in the sending and receiving of emails, logging into SFTP servers etc etc for use within COS codeTo manage external passwords we could use LastPass or any other proprietary password loggers, but I need to be able to call them as part of the automation (COS code) and occasionally visually look them up to "remind" the staff of their passwords.any suggestions as to the best class data constructs to handle this scenario. Should the whole table be encrypted, only the passwords etc. #ObjectScript #Security #Caché 0 9 0 398
Question Kevin Furze · Sep 20, 2018 fetch ip address of cache installation I'm using cache win10-x64 version 2017.2.1.801I want to uniquely identify the installation of cache, and from that create a meaningful unique folder names to store files. so to generate \192-168-1-100\KEVDEV\testfolder \ and \192-168-1-5\LIVE\testfolder\so in this case, I could- use the IPaddress and thesecond part of $SYSTEM (cache instance name) - at least this way, I can instantly see where it came from with little risk of overwriting between cache instance. #Caché 0 10 0 1,002
Question Kevin Furze · Apr 13, 2018 creating a macro with an unknown number of parameters I use macros everyday, but its the first time I want to create a macro like thisI want to create a new macro whereby I can pass a variable amount of parametersthe macro (much simplified version) would be #define myMacro(%params) $listBuild(any Number Of %params I pass in)so I want to be able to call $$$myMacro(user,ID,vehicle) ie 3 parameters would generate$lb(user,ID,vehicle)but equally I might want to call that same macro $$$myMacro(companyID) ie 1 paramter and would generate$lb(companyID) #Caché 0 4 0 351
Question Kevin Furze · Mar 16, 2018 translation of data ready to push to and from a JSON restAPI most of my jSON data is single words, but when it comes to sending chunks of a memo/email via JSON, that totally differentwhich is the correct conversion process to prepare data ready to insert into the data part of a JSON string so that all problem characters are convertedJSON of course crashes if you use the wrong format of quotes (single or double) and you ned up having to use " and \' to get around that but is there a simple call to something that will just take care of preparing the data from the JSON string both on the inward and outward part of JSON #JSON #Caché 0 13 0 422