Question Anna Golitsyna · Dec 14, 2022 How to get current routine line? I am familiar with $TEXT which can get you any line in the current routine provided you know the offset. For example, $T(+1) will get you the first line of the current routine at the run time. In the same vein, how do I reference the current line number/offset at the run time? Something like $T(+$CURRENTLINENUMBER) where $CURRENTLINENUMBER is not yet known to me function. The sample below would write 3 as the line number. RTNNAME S A=1W $CURRENTLINENUMBER #Key Question #ObjectScript #Caché 1 13 1 249
Question Anna Golitsyna · Oct 13, 2021 ObjectScript analog of Find with Match Element Type Is there an ObjectScript analog of Find with Match Element Type option? I know there is an ObjectScript analog of Find in Files, Studio.Project.FindInFiles and Studio.Project.FindInProject, but I failed to locate so far an analog of Edit/Find. I am specifically interested in Match Element Type option so I could search across selected files for globals. Somehow Studio.Project.FindInFiles does not offer this option natively. #Caché 0 2 0 232
Question Anna Golitsyna · Oct 8, 2021 Object script analog of RCOPY I am trying to figure out the best ObjectScript analog to mimic, more or less, the %RCOPY functionality. What would be ObjectScript method(s) if any to copy a routine from the current namespace to another one and compile it there? #ObjectScript #Caché 0 12 0 230
Question Anna Golitsyna · Aug 6, 2021 Cache routines: Date and Time Saved vs. Date and Time Modified My objective is to find routine's Date/Time Saved someplace inside Cache. The routine's Date/Time Modified as returned by various queries like %Library.RoutineIndex and as seen on the File Open screen is actually Date/Time Compiled last, not Date/Time Saved last. Does anyone know if Date/Time Saved is created when the Save icon is pressed or the routine is imported? Such a timestamp should be immune to subsequent compilations with no changes. #Caché 0 5 0 216
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 182
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 211
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 381
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 141
Question Anna Golitsyna · Dec 11, 2020 %Net.SMTP and Gmail I am trying to send email via smtp.gmail.com. #Caché 0 3 0 393
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 417