Question Anna Golitsyna · May 12, 2021 $preprocess failure There is an undocumented command, $preprocess, that can be called as below. In this case it takes the class name and converts its code into a text array. That includes comments as well. Two questions about it if you know: #Caché 0 8 0 275
Question Anna Golitsyna · Feb 5, 2021 Need on Audit event functionality Hi everybody, Is there any functionality I could use that triggers real time user-defined code on certain audit events? Right now I am interested in triggering such code on a routine modification event, like the one below. I do know how to access this record programmatically, via %SYS.Audit. Thanks in advance,Anna #Security #Caché 1 8 0 355
Question Anna Golitsyna · Jan 19, 2021 Debugging: Lost/Missing debugging functionality I have multiple projects that I utilize when debugging in Cache Studio. One of my projects suddenly lost the ability to step through commands with the yellow box and the cursor moving though code lines. The cursor just sits at the entry line while variables apparently do change. Interestingly enough, if I change the project and the debug target, the "yellow box" ability is still there. Apparently losing this functionality is by project/debug target/whatever. The goal is, of course to return it back but how? #Debugging #Caché 0 24 0 762
Question Anna Golitsyna · Jan 8, 2021 SQL: How to make WHERE work? Hi, The question is about queries on the System->SQL page. I have a class with a few columns on a global and the test output looks as expected, below. This works as expected as well returning a single row: select * from Utils.RoutineAuditReport where counter=4. However, other columns give an odd error like " Field 'AG' not found in the applicable tables^ SELECT * FROM Utils . RoutineAuditReport WHERE UserR = "AG". As you can see below, both the UserR column and the AG entry in it do exist. What could be the problem? Thanks in advance,Anna #SQL #Caché 0 2 0 217
Question Anna Golitsyna · Dec 11, 2020 %Net.SMTP and Gmail I am trying to send email via smtp.gmail.com. #Caché 0 3 0 769
Question Anna Golitsyna · Nov 11, 2020 Running code on another machine Hi everybody, Is there a way to run code on another machine? Of course, all authentication info is known. I know only about RemoteResultSet but that seems to be query specific. #Access control #Namespace #Caché 0 22 1 622
Question Anna Golitsyna · Sep 11, 2020 Automatic Watch variables I come from Visual Studio and now I use mostly Cache 2017 Studio. One debugging functionality I miss dearly is current local variables automatically appearing in the Watch Variables window together with their values. Yes, I can hover or type them myself but both actions take extra time which is especially noticeable when debugging unfamiliar code across many routines. Any Cache settings or plugins to that effect? If not then why not? And if nothing else is there in Cache, what are the alternatives or hacks in this respect? Anna #Debugging #Caché 0 12 0 390
Question Anna Golitsyna · Sep 1, 2020 Importing globals limitations and errors Hi, I exported selected globals from a Cache 2017 database into a single 4 Gb gof file. Now I tried to import from this file via Management Portal on a different machine . Only about half of the globals was imported and my attempts to select additional globals led to nothing, no new globals have been imported. Well, obviously I am mildly curious what's going on and how can I see the corresponding error which did not appear in the Import window but I can also shrug it off and consider what should I do next. #Data Import and Export #Caché 0 23 0 1.2K
Question Anna Golitsyna · Aug 19, 2020 Class properties from class name Hi, I'd like to compare classes in two namespaces, whether the corresponding .cls code exist in both namespaces or not, and if it does exist in both namespaces, whether the CLS code is identical. If there is such a routine out there the better, I'd like to see it. If not, I know how to get a list of classes in each namespace and I can check currClss.TimeChanged. What I cannot find is the following: #Databases #Caché 0 8 0 521