go to post Eduardo Sansin · Oct 30, 2024 On the managment portal I can see you ran the query using the SELECTMODE "Display mode" Try to set the SELECTMODE to "Display mode" when creating the instance of %SQL.Statement: set tStatement = ##class(%SQL.Statement).%New(2) SELECTMODE available options: 0 - Logical mode1 - ODBC mode2 - Display mode Certifications & Credly badges:Eduardo has no Certifications & Credly badges yet.Global Masters badges:Eduardo has no Global Masters badges yet.Followers:Eduardo has no followers yet.Following:Eduardo has not followed anybody yet.
On the managment portal I can see you ran the query using the SELECTMODE "Display mode"
Try to set the SELECTMODE to "Display mode" when creating the instance of %SQL.Statement:
set tStatement = ##class(%SQL.Statement).%New(2)
SELECTMODE available options:
0 - Logical mode
1 - ODBC mode
2 - Display mode