Show display mode in SQL query
Hi Guy,
when running a query on properties with by default it shows VALUELIST, how can get DISPLAYLIS, in my class methods not SMP?
Thanks
Product version: Caché 2018.1
Discussion (4)0
Comments
You need to create a instance of %SQL.Statement with the first parameter of %New method iqual 2.
#Dim stmt As%SQL.Statement = ##Class(%SQL.Statement).%New(2)For more details see https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_dynsql#GSQL_dynsql_objinstance
Thanks Silva
%EXTERNAL(expression)
https://docs.intersystems.com/iris20231/csp/docbook/Doc.View.cls?KEY=RS…
Thank you very much, this answer my question