Caché | InterSystems Developer Community

Question

Caio Timm · Jan 22, 2025

Transform rows to colums or colums to rows

Hello guys,

I need to tranform columns into rows or rows into columns.

I'm using only SQL Cache.

The code:

SELECT
    codRepresentante
    ,vendasAbril
    ,vendasAgosto
FROM
    Ped.MetasRepresen
WHERE ano = 2024

The columns:

#SQL #Caché #InterSystems IRIS

0 1

0 145

Question

Lucas Galdino · Jan 19, 2025

cconsole alarm: ROLLFAIL: <STORE>rbbulk+27^ROLLBACK

Hi experts, please, do you know cause this errors in cconsole?
I'd like know what can I investigate.

#Error Handling #Caché #HealthShare

0 1

0 104

Question

Andre Ribera · Jan 21, 2025

In Studio is there a way to access the code that flags whether a project has unsaved changes? (is there a property that controls the "star" on unsaved projects?)

I'm working on some code that would benefit from being able to see whether or not a project file has been saved in Studio.

I can see when I make changes, that the project name has an asterisk added to it:

#Studio #Caché #HealthShare #InterSystems IRIS #InterSystems IRIS for Health

0 2

0 105

Question

Oliver Wilms · Jan 19, 2025

Where did my variables go? Without Exclusive NEW, now I get <UNDEFINED>

I inherited some legacy MUMPS / ObjectScript code. A code review identified an exclusive NEW and that is not allowed per our coding standards.

The original code contains:

RUN(CALL,DRVNAME)
S $EC=""
S ^TMP($J,"RMPV","DRVNAME")=DRVNAME
N TMPFILE,OLDIO
S OLDIO=$IO
I $G(^TMP("RMPV","SILENT"),1) S IOP="NULL",%ZIS=0 D ^%ZIS I '$G(POP,1) U IO
D INIT^@DRVNAME
D ; scope variables
.N (DUZ,CALL) ; Protect %response
.S IOF="""""",IOM=80,U="^"
.D @CALL
U OLDIO
Q

#ObjectScript #Caché #InterSystems IRIS for Health #InterSystems IRIS

0 3

0 142