Caché | InterSystems Developer Community

Question

omer · Oct 1

Execute a routine with argument by name - Without using Xecute!

Hello everyone,
so lets say i have the following:

Hello
Q
say(arg)
w arg
Q

and i am trying to execute it by its name such as:

s a = "say^hello"

*execute the name inside a*

now I know for a fact that if say were written without any argument then do @a would work!

but I can I pass an argument in this case?
I don't want to use Xecute because I am in need of really high performance code.

#Caché #InterSystems IRIS

1 2

1 49

Question

omer · Sep 29

Run a routine that was created and compiled with %Routine library

I created and then compiled a routine using the %Routine library

s routine = ##class(%Routine).%New(fileName_"."_extension)
d routine.Write(parsedRule)
//s status = routine.Save()
s status = routine.SaveStream(,.refresh)
if ($$$ISERR(status)) throw status

#Compiler #Caché #InterSystems IRIS

0 2

1 36

Question

Robert Stephens · Sep 30

Combine all rows in select into one comma delimited string

I've got a select statement bringing back one value, I want to combine all rows into one comma delimited string. So for example:

SELECT First Name

FROM mydb.People

I get a list of names:

John

Fred

Sarah

Carl

Jane

Julie

Instead of having 6 rows in the result, I want one row, with one cell that has "John,Fred,Sarah,Carl,Jane,Julie"

Is there a way to do that?

#Caché #InterSystems IRIS

0 2

0 35

Announcement

John Murray · Sep 26

DX Jetpack 2024 edition brings three new extensions to VS Code users

See the new team members in action:

https://www.youtube.com/embed/PdndX1p7pjc
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Try them online for yourself:

https://gitpod.io#snapshot/b31bdf9c-4657-402a-a2d

Get it from the Extensions view inside VS Code, or here in Marketplace.

#REST API #Studio #Tools #VSCode #Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health

Open Exchange app

2 0

0 37

Question

Alan Nguyen · 9 hr ago

Create a CVS file with escape sequence to highlight the word in red

Hi,

I try to create a tab delimiter file with bold header, when I convert the file into Microsoft Excel, it has a bold header. The file can be in text or CSV exension.

Thank you.

Alan

#CSV #Caché

1 2

0 25