go to post Robert Cemper · Mar 5, 2021 Stay tuned! I'm almost done (most likely before Monday) with a demo of how you can make a soft transition.
go to post Robert Cemper · Mar 2, 2021 @11: 1:1 could be a degraded 1:N relationship orby inheriting from a base class as mentioned earlier: "Employee Extends Person" many-to-many can be covered as M:N relationship as I described in my article 3 years ago.
go to post Robert Cemper · Mar 2, 2021 @9.9. storage is generated once if not existing yet.you may change it manually (typically data location global) as long as there is nothing stored yetotherwise you lose the existing content. Or you copy it to the new location.My article The adopted Bitmap shows such an example [actually also in contest}
go to post Robert Cemper · Mar 1, 2021 6 & 7 are side effects of object inheritance.Think of a class Person.But Employee Extends PersonSimilar Students Extends Person tooSo you have 3 tables but all are Persons Some with extension some not. @6: Table Employee corresponds to class Person and to class Employee @7: So class person corresponds to Table PERSON, EMPLOYEE , STUDENT
go to post Robert Cemper · Feb 24, 2021 #20. Is slightly exaggeratedofficial docs present it differently.https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=ITECHREF_json https://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?LIBRARY=%25SYS&CLASSNAME=%25Library.DynamicArray
go to post Robert Cemper · Feb 24, 2021 Depending on the environment you use embedded SQL the variable SQLCODE may not reach you. This is related to variable scoping. Therefore it is better to use any variant of Resultset.For variable scoping see my article here
go to post Robert Cemper · Feb 21, 2021 Nice! Only 666 characters in sequence. A mystic number I like it
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 ?
