go to post Robert Cemper · Nov 24, 2022 Add this line to your test: Set object = ##class(dado.TblTeste).idxFieldOneFieldTwoFieldThreeOpen(1, 2, "") If 'object Do $system.OBJ.DisplayError() So you see the reason for failing Open by unique index reqires an EXACT match
go to post Robert Cemper · Nov 16, 2022 Once you have your own children you would learn that there is no need to TEACH interest.If your children accept you they follow your path. anything else is just academic nonsense. So proven by my 3 highly adult and successful children and 4 grandchildren following the traces.
go to post Robert Cemper · Nov 12, 2022 my review on OEX now shows also if the package supports IPMall 19 reviews have been updated
go to post Robert Cemper · Nov 9, 2022 To achieve the expected result of individual storage you may take this approach: Class Test.NewClass Extends %Persistent [ NoExtent ] { Property Name As %String [ Required ]; Index NameIndex On Name [ Unique ]; } and Class Test.NewClass1 Extends Test.NewClass { Storage Default { <Data name="NewClass1DefaultData"> <Value name="1"> <Value>%%CLASSNAME</Value> </Value> <Value name="2"> <Value>Name</Value> </Value> </Data> <DataLocation>^Test.NewClass1D</DataLocation> <DefaultData>NewClass1DefaultData</DefaultData> <IdLocation>^Test.NewClass1D</IdLocation> <IndexLocation>^Test.NewClass1I</IndexLocation> <StreamLocation>^Test.NewClass1S</StreamLocation> <Type>%Library.CacheStorage</Type> } } and you see:ERROR #5808: Key not unique: Test.NewClass1:NameIndex:^Test.NewClass1I("NameIndex"," A1")
go to post Robert Cemper · Nov 9, 2022 no big surprise.if IDKEY <> PrimaryKey then PrimaryKey is just a UNIQUE Key on some property. I expected it as on object side you have %OpenId() but no %OpenPrimary() or similar.only Classmethod <uniqueProperty>KeyOpen(...)
go to post Robert Cemper · Nov 7, 2022 if you know the process id then $SYSTEM.Process.Terminate( . . .) should terminate it
go to post Robert Cemper · Nov 7, 2022 there is a quite wide selection of licenses.the best for details is to contact your local sales rep from InterSystems to find your optimal solution
go to post Robert Cemper · Nov 6, 2022 All said: the processor has too many cores which is not allowed by Community edition license So get an official distribution and an official/evaluation license: https://wrc.intersystems.com/wrc/coDistEvaluation.csp
go to post Robert Cemper · Nov 3, 2022 Following this discussion since beginning I'm wondering about the variant I've learned.my personal approach would be.#1)have an exact copy of your class also pointing to the same storageremove all index definitions from that clone classrun your bulkload#2)if you don't want to have the same storagejust eliminate the index definitions in the copyclean its storage and run your bulk loadfinally, merge the resulting globals #' .)It's not pure OO,but writing to storage is never OO with Caché or IRIS
go to post Robert Cemper · Oct 28, 2022 GREAT!Looks like embedded Py starts to understand how IRIS really works inside !!!!
go to post Robert Cemper · Oct 27, 2022 I'd say it's a bug in Query Generator.A workaround in DB-API just might hide the real cause. If you are lucky the bug is fixed by the next release or the next after or some future release
go to post Robert Cemper · Oct 27, 2022 thanks for confirming my diagnose- that's why I used "+id as id1" to break the link to index global- and :BTW: ORDER BY 1 ; just using column position shows the same bug
go to post Robert Cemper · Oct 26, 2022 set claim=##class(Claim).%OpenId(claimnum) ; or similar set line=##class(ClaimLine).%OpenId(linenum) ; or similar do claim.ClaimLineRel.Insert(line) now your query should work