go to post Robert Cemper · Sep 29, 2017 That's fine and nothing new.You missed my point:With the Class Query it's not self explaining if params got to Prepare() or to Execute()http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?P...I just learned from John Murray a few comments abovePrepare() is for dynamic SQL, but in your case it's a class query you want to run.So change your rs.Prepare call to be an rs.Execute one.that you don't need a prepare with a Class Query.I wasn't aware of that until a few hours ago.Then it's obvious that any param has to go to Execute().
go to post Robert Cemper · Sep 29, 2017 SQL Error 417 = Security ErrorYou should check your access rights inside - Windows- Caché
go to post Robert Cemper · Sep 29, 2017 Hi Ken,For some odd reason Execute() requires he same parameters as Prepare() again !%SYS>set rs=##class(%ResultSet).%New("Config.MapGlobals:List")%SYS>write rs.Prepare("ENSDEMO","*")1%SYS>write rs.Execute("ENSDEMO","*")1%SYS>write rs.Next()1%SYS>..... Just hacking around.
go to post Robert Cemper · Sep 28, 2017 If the owner of a table is _PUBLIC, users do not need to be granted object privileges to access the table.http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...based on that you can build an OWNER that has also limited rights (only SELECT, REFERENCES, .. or whatever) So you do it for this Owner only
go to post Robert Cemper · Sep 26, 2017 As you said all are uniqueI try to summarize it simple:IDkey is used in storing object s. Best to be translated : Global subscript of data store.Could be defaulted to %Integer >0Unique key defines an index with unique values of a property in parallel to IDkey. Checked during object save.PrimaryKey comes from SQL world and could be interpreted mostly as a synonym to IDkey
go to post Robert Cemper · Sep 25, 2017 ENSDEMO>d $system.SQL.Shell()SQL Command Line Shell---------------------------------------------------- The command prefix is currently set to: <<nothing>>.Enter q to quit, ? for help.ENSDEMO>>select * from Ens_Config.Credentials1. select * from Ens_Config.Credentials ID BusinessPartner PasswordObject Password SystemName Username .... Rows(s) Affected
go to post Robert Cemper · Sep 25, 2017 or more object stylewrite ##class(%Library.TimeStamp).XSDToLogical(obj.biometrics.%Get(0).timestamp)
go to post Robert Cemper · Sep 22, 2017 Just add another IF condition and replace all "Country" by " Relation"If ($g(pInfo:filters("Relation"))'="") { Set tWHERE = tWHERE _ $S(tWHERE="":"",1:" AND ") _ "Relation %STARTSWITH '" _ pInfo:filters("Relation") _ "'"}
go to post Robert Cemper · Sep 22, 2017 assuming variable payload holds your content of "payload"set profileId=$piece($piece(payload,"profile_id"":""",2),""",")set timestamp=$piece($piece(payload,"timestamp"":""",2),""",")
go to post Robert Cemper · Sep 20, 2017 try Do ##class(%SQL.Util.Procedures).CSVTOCLASS(2, .rowType, pFileName, pDelimiter,,1) ;; no defaults if not required or the EXACT count: 9 params = 8 comma ;; I counted 9 and/orProperty Name As %String (MAXLEN="");and/or;; the last comma in rowType looks also suspect to me.set rowType=" . . . . ,ActiveStatus Boolean" HTH
go to post Robert Cemper · Sep 20, 2017 yeah,that's for slow typing senior writer's without autocomplete. BTW. wrapping of this editor is sometime more than disturbing.
go to post Robert Cemper · Sep 20, 2017 It's still the same answer as in one of your previous questions:only difference 1 hour instead of 24 hourshttps://community.intersystems.com/post/configure-business-serviceSee the example on ENSDEMO namespace
go to post Robert Cemper · Sep 20, 2017 like this:set ts=20160105125915 ;; convert to $Hset th=$zdth($e(ts,1,8)_" "_$e(ts,9,10)_":"_$e(ts,11,12)_":"_(ts#100),8) ;; convert to UTCset tu=$ZDTH(th,-3) ;; show $ZTS format (on UTC+0200 Vienna,Austria)write $ZTD(tu,3)2016-01-05 13:59:15You can of course do it in a single unreadable long cascaded function chain.HTH
go to post Robert Cemper · Sep 19, 2017 Sebastian,I share your considerations.My personal interpretation of the IRIS message: - go for Java for any application code and make use of the large developer market - stay in COS ( or .int) for internal DB manipulation with in depth "System Engineers"
go to post Robert Cemper · Sep 19, 2017 my full support to 3 !!!! and to 5, 2, 4 in this priority.The difference between ANSWER and COMMENT causes more confusion than being helpful.Especially in the actual sequence.Comment to Answers eventually may make sense. More than once I found myself in a Comment where it should have been an Answer. My suggestion: -handle all editing just in a modal pop-up .- allow deleting (or hiding) your entry if you don't feel it appropriate anymore.
go to post Robert Cemper · Sep 15, 2017 WebServerPort =Web Server port number. Setting this number to any non-zero value enables the Web Server on that port. If you set this number to 0, the Web Server is disabled.
