All
Accepted answers
Daniel Aguilar · Sep 21, 2023 go to post

Hello @Evgeny Shvarov 
Thanks for sharing the bonuses results.

Please, can you check the IrisApitester puntuation?

It uses:

-Embedded phyton

-Docker

-ZPM

Or maybe it’s because it’s an update to an existing App?

Thanks!

Daniel Aguilar · Jul 7, 2023 go to post

It happened to me too. My votes were deleted I had to vote again  and I don't know who voted for me

Daniel Aguilar · Jun 29, 2023 go to post

Hello, I'm getting this error when I execute: publish {myPackageName}

ERROR! Publishing module, authorization required.

Can you help me?

Thanks!!

Daniel Aguilar · Feb 11, 2023 go to post

Hello,
Please add bonuses `Second articule (translation) and YouTube vídeo to cos-url-shortener Project.

I added embedded Python too (but maybe too late) xD

Thanks!.

Daniel Aguilar · Jun 21, 2022 go to post

Hi, Nicola

I think best option is $Select as Jolyon write, but you have this option too

set a=0 set:(a>b) a=1
Daniel Aguilar · Mar 31, 2022 go to post

Thanks Alexey for your answer but as Jhon says $now doesn't adjunt for Dailyght Save Time and I need it.  wink

Daniel Aguilar · Mar 15, 2022 go to post

Good morning Michael,

I haven't worked a lot with stored procedures but when I have worked with them, I did it like this.

TestSQLProc()
 New stmt,status,rSet,SQLQuery  

 SET SQLQuery = "SELECT PackageName.ClassName_ProcedureName('parameter')" 

 Set stmt = ##class(%SQL.Statement).%New()
 Set status = stmt.%Prepare(SQLQuery) 

 If status'=1 
 { 
    Set return="%Prepare failed:" Do $System.Status.DisplayError(status) Quit
 } 

 Set rSet = stmt.%Execute() While rSet.%Next()
 {
    U 0 W rSet."ColumnName"
 }    

Q

I think that your problem is that you're trying to get information using Call instead of Select.

I hope it helps you.

My best,

Daniel Aguilar · Jun 15, 2021 go to post

Hello Werner.

I had the same problem and I solved it adding this to the answer:

Do %response.SetHeader("Access-Control-Allow-Origin","*")

Regards,

Daniel Aguilar · Nov 9, 2020 go to post

Good morning,

Sorry, I was wrong when writing the question, effectively what I am receiving is a empty string and what I want to store is an null.

David,
I have been trying to overwrite the Normalize method but it is not working for me, maybe I am not overwriting the method well

ClassMethod myPropertyNormalize(%val As %CacheString) As %String [ CodeMode = generator, ServerOnly = 1 ]
{
s str=""
//s code="%val" //i %parameter("TRUNCATE"),%parameter("MAXLEN")'="" s code="$e(%val,1,"_(+%parameter("MAXLEN"))_")"
//$$$GENERATE(" Q "_code)
$$$GENERATE(" Q "_$tr(code,$c(0),""""))
QUIT $$$OK
}

I am doing it right? (I guess not xD )

Thanks!.

Daniel Aguilar · Apr 15, 2020 go to post

I missed the webinar , but I'm very interested...crying

Is a recording going to be uploaded? angel