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

Regards

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

Hi @Anastasia Dyubaylo 
Is Kick-off webinar recoding available ?
Thanks

Congratulations to ALL. It was nice competition

That's great. Thank you

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

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

Congratulations to all community members 👏 

Congratulations to the all

Congratulation to all. Thanks DC

Hi Mr. Evgeny Shvarov

Please note that I have added OAuth2 support along with Article for Data_APP_Security app

Thanks

Hi,

I am requesting points for translated article in Spanish for Data_APP_Security app

https://es.community.intersystems.com/post/c%C3%B3mo-crear-usuarios-conc...

Thanks

Hi Mr. Evgeny Shvarov

Thanks for sharing 

Please note that Data_APP_Security app already have article on DC

Thanks
 

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")
}

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") }