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

Congratulations! DC helped me a lot. good to see DC is growing.

Hi @Olga Zavrazhnova, I will participate. Thanks 

Try getGeneratedKeys() function 
https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=BGJD_coding

Thanks

Try getGeneratedKeys() function 
https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=BGJD_coding

Thanks

Add any false statement in where clause e.g add where 1 = 0

Thanks