go to post Eduard Lebedyuk · May 26, 2017 Please note that It's not recommended to use %OnAddToSaveSet(), especially performing heavy operations there.
go to post Eduard Lebedyuk · May 24, 2017 Like this: set p = ##class(%SYS.ProcessQuery).%OpenId($job) set p.UserInfo = "My Text" kill p
go to post Eduard Lebedyuk · May 19, 2017 In your %XML.Reader set IgnoreSAXWarnings to 1. In your XML enabled classes set params: Parameter XMLIGNOREINVALIDTAG As BOOLEAN = 1; Parameter XMLIGNOREINVALIDATTRIBUTE As BOOLEAN = 1; This would allow for errors to be skipped, but they wouldn't be reported either. I'm not sure if the behavior you want is possible without some modifications.
go to post Eduard Lebedyuk · May 18, 2017 Here's a few thoughts:Get list of pivotsFor eachGet MDXTry to execute MDXIf it fails, record the errorAggregate/display errorsShould be doable. DeepSee API has all the required functions.
go to post Eduard Lebedyuk · May 17, 2017 GuruBaseAllah.BLZServiceSOAP11porthttp class already exists.
go to post Eduard Lebedyuk · May 16, 2017 Check UserAction method of %Studio.Extension.Base class. You can call CSP pages from there.
go to post Eduard Lebedyuk · May 14, 2017 Write statement does what it's name implies - outputs characters into a current device. It's a way to go if you're working from a terminal, but ZEN does it's own device management, so writing into a current device interferes with ZEN also writing into current device, which causes an error. To make it work check if there's no data (SQLCODE=100) and set OutVal to empty (or error message) and work with that on a client.
go to post Eduard Lebedyuk · May 13, 2017 HttpResponse property contains response. Here's a sample: Set req = ##class(%Net.HttpRequest).%New() // build the request Do req.Post("url") Set str = req.HttpResponse.Data.Read() Write str
go to post Eduard Lebedyuk · May 13, 2017 Add on insert trigger. myFlag value should be available there.
go to post Eduard Lebedyuk · May 12, 2017 To get query text you can query %Dictionary.QueryDefinition. For example: SELECT * FROM %Dictionary.QueryDefinition WHERE Parent = class Would return all queries for a class. As for getting only columns, here's some ideas: If the query was executed somewhen and cached, there would be a generated class, holding metadata among other thingsThere are generated methods QueyNameGetInfo and QueryNameGetODBCInfo - they return metainformation about query columnsExecute the query and iterate over metadata What do you want to achieve? Why is executing a query not possible?