go to post Robert Cemper · Aug 28, 2017 Thank you Heikki,I have passed this "cooling" too and missed the "heat." So my mind is back and the body stays at home
go to post Robert Cemper · Aug 26, 2017 Hi Lexi,if you prefer to work unplugged you also may use HAMSTER (it's bilingual DE/EN)http://www.elbiah.de/hamster/pg/*
go to post Robert Cemper · Aug 24, 2017 Did it work ? %GCMPCompares two globals in the same or different namespace.
go to post Robert Cemper · Aug 24, 2017 Looks like running the query but not getting a resultset.You seem to be reading past the last row you got.Hardcore fix, if noting better. Wrap it in Try { } Catch {} /// it's not my favourite
go to post Robert Cemper · Aug 24, 2017 by lack of responses I converted it from a question to an article + comment
go to post Robert Cemper · Aug 24, 2017 Then that's the curse of $PIECE() with no chance to fake it.So name the separator # ' " . / \ ~ ^ ...anything but ,[ as Johnny Cash was singing: ... anything but "Sue" ]
go to post Robert Cemper · Aug 24, 2017 I did a short test fiddling arouned ^Samples.PersonIan to demonstrate the output.SAMPLES>Do $SYSTEM.OBJ.ValidateIndices("Sample.Person","",1,2) Checking index integrity for class 'Sample.Person'Begin time: 08/17/2017 21:41:25 Verifying data from data map 'IDKEY' is indexed correctly...Index 'NameIDX', entry ^Sample.PersonI("NameIDX"," CHANG,QUIGLEY H.",39), has differences between master map data and index map data. CorrectedIndex 'NameIDX', entry ^Sample.PersonI("NameIDX"," CHANG,DAN L.",40) missing. CorrectedIndex 'NameIDX', entry ^Sample.PersonI("NameIDX"," CHADWICK,OLGA E.",43) missing. CorrectedIndex 'NameIDX', entry ^Sample.PersonI("NameIDX"," CANNON,BARBARA W.",81) missing. CorrectedData Map evaluation complete, 200 rows checked, 4 errors found, elapsed time: .004733 seconds Verifying data from index map "$Person" is correct...Index map "$Person" evaluation complete, 0 errors, elapsed time: .000691 seconds Verifying data from index map NameIDX is correct...Index 'NameIDX', entry ^Sample.PersonI("NameIDX"," CEMPER,DAN L.",40), data differs for field 'Name' between data and index map. CorrectedIndex map NameIDX evaluation complete, 1 errors, elapsed time: .001331 seconds Verifying data from index map SSNKey is correct...Index map SSNKey evaluation complete, 0 errors, elapsed time: .001195 seconds Verifying data from index map ZipCode is correct...Index map ZipCode evaluation complete, 0 errors, elapsed time: .001255 seconds %ValidateIndices is complete, total elapsed time: .012282 seconds SAMPLES> This looks good so far.
go to post Robert Cemper · Aug 23, 2017 start hereit might not be as trivial as you thinkhttp://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...more...HTH
go to post Robert Cemper · Aug 23, 2017 to work down a collection of varying number of elements I'd use this kind of loopin this case it's a double loopFor res=1:1:callresponse.result.Count() { Continue:'$IsObject(callresponse.result.GetAt(res) For err=1:1:callresponse.result.GetAt(res).Count() { Continue:'$IsObject(callresponse.result.GetAt(res).errors.GetAt(err) Set context.ErrorMessage= callresponse.result.GetAt(res).errors.GetAt(err).message - - - - } }This is the paranoic version!If you trust ENSEMBLE you may skip the check for $IsObject()more...HTH
go to post Robert Cemper · Aug 23, 2017 this could have been what you were looking for.it's pure CSP.Light weight EXCEL downloadhttps://community.intersystems.com/post/light-weight-excel-download more... HTH
go to post Robert Cemper · Aug 23, 2017 ! ", " is seen just as another string textYou need the unicode character here to make it working columnHeaders="house number"_$C(65292)_" appartment"
go to post Robert Cemper · Aug 23, 2017 ! ", " is seen just as another string textYou need the unicode character here to make it working columnHeaders="house number"_$C(65292)_" appartment" sorry, was in the wrong context before
go to post Robert Cemper · Aug 21, 2017 Alexey,with $ZF(-1,command) you are at OS level.Nothing prevents you from extending command to a script that writes its pid in a file.using $JOB_".pid" or similar as file name should be enough to identify it.So after a moderate HANG your pid should be available.I prefer this to using pipes or other sophisticated solutions (e.g. listening on a TCP/IP or UDP port, ...)as you get an embedded trace for free HTH
go to post Robert Cemper · Aug 21, 2017 John,II just visited your post.The hidden expectation is: ISC knows it better. This might fit in average.But there are other people like you that are at least as well qualified as ISC specialists are. What's your label ?And thinking on nodes.js I have my personal preferences outside ISC . I have no problem if i'ts done but I'm not enthusiastic about.
go to post Robert Cemper · Aug 21, 2017 online docs don't give a direct hint.so my shot from the hip: selection expression - $select(), $case() where you get a value based on a conditiondata expression - anything that sets, modifies, composes data.this is a quite academic view since data expressions may contain selection expressionsand selection expressions may contain data expressions.both variants and any mix of it are quite common in COS more...HTH