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 209
Question Anna Golitsyna · Dec 11, 2020 %Net.SMTP and Gmail I am trying to send email via smtp.gmail.com. #Caché 0 3 0 724
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 596
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 368
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 500