go to post Robert Cemper · Feb 19, 2021 <CLASS DOES NOT EXIST>%Close...is typical if try to access resultset or just delete rset after leaving namespace %SYS.Just reproduced it. %SYS>w !,rset.%Next(),?5,rset.%Get("Directory"),!?30,rset.%Get("Size"),?40,rset.%Get("MaxSize") 1 c:\intersystems\iris\mgr\enslib\ 163 Unbegrenzt %SYS>ZN "USER" USER>k rset <CLASS DOES NOT EXIST>%CloseCursor+3^%SQL.ClassQueryResultSet.1 *SYS.Database USER>
go to post Robert Cemper · Feb 19, 2021 #1 there is no "SELECT LAST_SERIAL()" #2 depending what your expectation on LAST is I see 2 possible workarounds#2A LAST = max: "SELECT MAX(test_id) FROM test" #2B LAST = latest: "SELECT test_id, MAX(ID) FROM test GROUP BY 2" #2B is based on the fact that you always have an auto-incremented ID and it's a shortcut of"SELECT test_id FROM test where id = (SELECT max(ID) from junior.test)"or"SELECT TOP 1 test_id FROM test WHERE ID < 999999999999999999 ORDER BY ID DESC"
go to post Robert Cemper · Feb 19, 2021 So, as by docs. SQLCODE=100 indicates that the SQL operation was successful,but found no data to act upon https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=RERR_sql#RERR_sql_noerr
go to post Robert Cemper · Feb 18, 2021 There is my example in OEX: Light weight EXCEL download if you omit the special setting of type, it is a normal html table.
go to post Robert Cemper · Feb 18, 2021 What I asked for: In your Method written in Objectscript, after &sql(update X_X.X set LocalEnvironment=1 where %ConfigName IN('X_X_X', 'Y_Y_Y')) Variable SQLCODE holds a success / failure code. That's what I asked for.see this example: https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=GSQL_esql#GSQL_esql_syntax_ampsqlor https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=GSQL_esql#GSQL_esql_code_literalsandhttps://docs.intersystems.com/iris20201/csp/docbook/DocBook.UI.Page.cls?KEY=RERR_sql#RERR_C136606
go to post Robert Cemper · Feb 18, 2021 You may stick with '/' and run $TRANSLATE(record,"/","~") just before writing the record to your file.DAT
go to post Robert Cemper · Feb 18, 2021 did you try ! or ? instead of ~ since ~ might be a reserved default separator to HL7
go to post Robert Cemper · Feb 18, 2021 What does SQLCODE tell you after your embedded SQL query?What is your real $ZV ?
go to post Robert Cemper · Feb 12, 2021 @Daniel Tamajon I'm using GitHub in browse to create this project. https://github.com/rcemper/try_embedded_pythonHow is the quality check started / triggered ? Is some minutes > 20 minutes ?
go to post Robert Cemper · Feb 8, 2021 I was searching this but looked for ManagerDirectory instead of InstallDirectory
go to post Robert Cemper · Feb 8, 2021 write $replace(##class(%File).ManagerDirectory(),"mgr","lib") independent of OS!
go to post Robert Cemper · Feb 8, 2021 All %R* routines are hidden in IRIS for good reasons.And they just survived for backward compatibility not for common use.And they use ZS ZI, ... and $Compile() function. ... and a bunch of $ZU(..) Manipulating routines from Terminal is not covered. VScode or Studio is expected and supported
go to post Robert Cemper · Feb 8, 2021 If you edit .INT routines from the terminal in the old MUMPS style using ZLOAD, ZSAVE, edit by X ^%you operate at a lower level than Studio, VScode, Atelier,... and deeper than any Source Control Hooks. Neither belt nor suspenders are available anymore. It's like heart surgery: Either you fix it or your patient is gone.
go to post Robert Cemper · Feb 5, 2021 the second line of the error msg tells you that SQLserver raised error 102 This error occurs when Adaptive Server detects a syntax error in a Transact-SQL® command or query. This error can occur when: A keyword is misspelled. ... You used a variable for a database name and your query contains a parser error; error 102 is raised because the batch was never executed.from:http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00729.1500/html/errMessageAdvRes/CHDGFCCJ.htmsuggestion: Check the SQL-name of the generated class samples.people
go to post Robert Cemper · Feb 5, 2021 Developing in the production environment is "high-risk extra class".This doesn't exclude to do development on the production SERVER (e.g by lack of HW)The most simple option is to have 3 namespaces in parallel. PRODUCTION (aka WORK), TEST, DEVELOPMENT.A better variant is to have a 2nd instance on the same SERVER machine for TEST & DEVELOPMENT.Git doesn't care which Instance you use.ZMP is not availaible in Caché.Docker is theoretically possible but quite an effort as you need to build your own image especially for a WIN environment and get the appropriate license for it.
