Show display mode in SQL query

Question

Question

Rochdi Badis · Apr 26, 2023

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)3

Log in or sign up to continue

Paolo Bolis · Apr 27, 2023

%EXTERNAL(expression)

1 0

score 2 · Answer 1 · 2023-04-26T07:51:06-04:00

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)

score 0 · Answer 2 · 2023-04-28T04:34:48-04:00

Rochdi Badis · Apr 28, 2023

Thanks Silva

0 0

score 1 · Answer 3 · 2023-04-28T04:34:31-04:00

Rochdi Badis · Apr 28, 2023

Thank you very much, this answer my question

1 0