go to post Daniel Aguilar · Mar 31, 2022 Thanks Alexey for your answer but as Jhon says $now doesn't adjunt for Dailyght Save Time and I need it.
go to post Daniel Aguilar · Mar 15, 2022 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,
go to post Daniel Aguilar · Jun 15, 2021 Hello Werner. I had the same problem and I solved it adding this to the answer: Do %response.SetHeader("Access-Control-Allow-Origin","*") Regards,
go to post Daniel Aguilar · Nov 9, 2020 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!.
go to post Daniel Aguilar · Apr 15, 2020 I missed the webinar , but I'm very interested... Is a recording going to be uploaded?
