All
Accepted answers
Muhammad Waseem · Jan 22, 2022 go to post

from local installation, follow below steps
- From Menu select Terminal > New Terminal
- Run irissession from installation directory (In my case its C:\InterSystems\IRISHealth\bin\) with instance name ("C:\InterSystems\IRISHealth\bin\irissession <instance name> ")
e.g C:\InterSystems\IRISHealth\bin\irissession irishealth 
Thanks

Muhammad Waseem · Jan 22, 2022 go to post

Hi,

If you are looking to connect to IRIS terminal from VS Code then first of all make sure docker container is running and then follow below steps:

- From Menu select Terminal > New Terminal
-Then  Run this command to connect to IRIS terminal
docker-compose exec iris iris session iris

Thanks
 

Muhammad Waseem · Jan 17, 2022 go to post

Many thanks to DC for all of your support, It was great contest and I learned a lot, Congratulations to all winners.

Muhammad Waseem · Jan 12, 2022 go to post

Hi Mr. Evgeny
Thanks for sharing the Bonuses Results.
Please note that online demo is available now for Medical Datasets application.

Regards

Muhammad Waseem · Jan 12, 2022 go to post

Thanks to DC for selecting me Global Master of the month 5 times since june 2021 and congratulation to all

Muhammad Waseem · Dec 23, 2021 go to post

Hi @Anastasia Dyubaylo
Thanks for sharing the post. 

I suggest to increase the length of Bio field to at least 500 characters instead of 250 as currently I am not able to paste embedded code of certification as it is exceeding the limit.

Thanks

Muhammad Waseem · Dec 23, 2021 go to post

ODBC drivers can be downloaded from :

WRC download > Components > ODBC Drivers  has
ODBC Driver, Cache and Ensemble, 2018.1....  several build for all supported Platforms

Thanks

Muhammad Waseem · Nov 16, 2021 go to post

set st = ##class(%SQL.Statement).%New(2,"Sample")
set sql = 3
set sql(1) = "select TOP 5 %ID as id, Name, DOB, Home_State"
set sql(2) = "from Person where Age > 40"
set sql(3) = "order by 2"
do st.%Prepare(.sql)
for type="txt","pdf","csv","html","xml" {
  set rs = st.%Execute()
  do rs.%DisplayFormatted(type,"C:\Temp\report")
}

Muhammad Waseem · Nov 16, 2021 go to post

Hi,

use  %SQL.StatementResult:%DisplayFormatted()
Please find below sample code(SAMPLE namespace):
set st = ##class(%SQL.Statement).%New(2,"Sample") set sql = 3 set sql(1) = "select TOP 5 %ID as id, Name, DOB, Home_State" set sql(2) = "from Person where Age > 40" set sql(3) = "order by 2" do st.%Prepare(.sql) for type="txt","pdf","csv","html","xml" {   set rs = st.%Execute()   do rs.%DisplayFormatted(type,"C:\Temp\report") }

Muhammad Waseem · Nov 4, 2021 go to post 
Try getGeneratedKeys() function 
https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=BGJD_coding

Thanks

Muhammad Waseem · Nov 4, 2021 go to post 
Try getGeneratedKeys() function 
https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=BGJD_coding

Thanks