go to post Robert Cemper · Nov 13, 2019 SqlComputeOnChange should trigger on INSERT while it should trigger only if the value is CHANGED by an UPDATE. If you need recalculation in any case you may use an ordinary Update TRIGGER to adjust your property as you need.
go to post Robert Cemper · Nov 9, 2019 Right! But without Git (several years back) . . . . . . . .It's a matter of organization and discipline anyhow.
go to post Robert Cemper · Nov 8, 2019 another way to explain your phenomenon: assume you have a.INC assume inside you have #DEFINE vaXYZ next, you have b.INC with an #include a now your class C with include b and using $$$vaXYZ compiles fine later #DEFINE vaXYZ is removed from a.INC NOTHING HAPPENS you have constructed a time bomb long time later you do any change on class C now your bomb crashes your compilation I experienced such a case where the bomb was sleeping for 5 years.Nobody remembered the change of a.INC and not the reason for the change.
go to post Robert Cemper · Nov 8, 2019 if your class inherits from some other the include may have gone there? typically explained by: "We do not reference it here. "
go to post Robert Cemper · Nov 8, 2019 It seems that you have lost the ????.inc the includes the definitions of$$$vaExtentGbl$$$vaSegment$$$vaSegmentGbl$$$vaDataSegName$$$vaDataDocNameeither you lost the related Include statement or the whole file is lost So in Studio run a "search in files" over *.inc for #Define vaExtentGbl#Define vaSegment#Define vaSegmentGbl#Define vaDataSegName#Define vaDataDocNameto find out which .inc you are missing. The query you changed is totally unrelated to it, as far as it seems.
go to post Robert Cemper · Nov 6, 2019 OK.It took some investigations to understand what's going on. the is a Class Parameter XMLUSEEMPTYELEMENT = 1;it switches between <Ping></Ping> and <Ping /> BUT: if ALL Properties of your reply are empty then you just get an empty body <soapenv:Body></soapenv:Body> as soon as you set some dummy value into Property Ping you get <Ping> </Ping>or you add a dummy property. Digging into %SOAP.... message classes shows, that the generated messages don't use XMLUSEEMPTYELEMENT parameter.
go to post Robert Cemper · Nov 6, 2019 Check XML projection of Property Pingespecially handling of null strings controlled by XMLNIL & XMLIGNORENULL parameter.see Handling Empty Strings and Null Values
go to post Robert Cemper · Nov 6, 2019 if you add to your data class Class NAMEHERE.myDate [ ClassType = datatype, ClientDataType = DATE, OdbcType = DATE, Not ProcedureBlock, SqlCategory = DATE ] these 2 methods you get a kind of self healing code.It is accessed every time you load or save your property ClassMethod LogicalToStorage(in As NAMEHERE.myString = "") As NAMEHERE.myDate [ CodeMode = expression ]{$s(+in'=in:$zdh(in),1:in)} ClassMethod StorageToLogical(in As NAMEHERE.myString = "") As NAMEHERE.myDate [ CodeMode = expression ]{$s(+in'=in:$zdh(in),1:in)}
go to post Robert Cemper · Nov 5, 2019 Hi Alex, "in logical Mode the date shows normal format, in my case, for example 10/1/2019" in logical mode you get the pure content from global which is here NOT a $H value !! $ZD() expects an Integer to convert => it is just +"10/1/2019" => 10 then $ZD(10) = " 10/1/1841" So it seems that some of your Dates are not stored using DisplayToLogigal resulting in an Integerbut written directly (e.g. coming from ZEN) into your object / global. To fix it you may run something like if +in'=in set in=$zdh(in))
go to post Robert Cemper · Nov 5, 2019 InterSystems Docker Imageshttps://wrc.intersystems.com/wrc/coDistContainers.csp
go to post Robert Cemper · Nov 4, 2019 I did a retry on a different instance and couldn't reproduce the message. I'm sorry.
go to post Robert Cemper · Nov 1, 2019 Hi Vic, I clicked on ACTIVATE, selected the key file but nothing changed. I got this one by mail this one: InterSystems IRIS Server for x86-64 (Microsoft Windows):256 Natural Language Processing (NLP), Sharding, Enterprise Cache Protocol (ECP) Same with the Demo Key I downloaded worked fine: LicenseCapacity=InterSystems IRIS 2019.1, Enterprise:64, Concurrent User, Platform Independent I'm wondering which license server is referred with a stand-alone installation.I feel lost.
go to post Robert Cemper · Oct 31, 2019 After using the correct license file the message was gone. But I still don't understand the "content" & context.
go to post Robert Cemper · Oct 30, 2019 For a more precise explanation: Table definitions with ALL indices are required and the complete query plans not just a summary. And also your version ( $ZV )
go to post Robert Cemper · Oct 30, 2019 It's a matter of design of the table. pls. provide the table description
go to post Robert Cemper · Oct 29, 2019 If RESTR_DATETo you try to change is part of the Idkey you can't do an UPDATE on it. Instead you need an INSERT with new Contents and DELETE of the old.
go to post Robert Cemper · Oct 28, 2019 and with ROW number select %VID as Row ,* from ( SELECT age , (Select sum(i.age) from sample.person i where i.id <= o.id and age < 20 ) as SubTotal FROM sample.person o where age < 20)
go to post Robert Cemper · Oct 28, 2019 As your table is not available I took a Table from SAMPLES using a subselect SELECT age , (Select top all sum(i.age) from sample.person i where i.id <= o.id and age < 20 ) as SubTotalFROM sample.person o where age < 20
go to post Robert Cemper · Oct 26, 2019 "cautionary M tales" is really ages old and outdated. But see it from reverse side: You can run without any change code that was written 40 years ago on PDP-11I've seen it and can confirm it.I know of no other system that allows spanning that range of time without touching the code. But you are not forced to write that style. Or you can even write your code in BASIC if you dislike COS.
