Hi Team,
When I use below statement , I got SQLCODE=0.
SET rs = ##class(%SQL.Statement).%ExecDirect(, "SELECT * FROM LISDB.ExternalUsers WHERE UserId = 83")
If I display above query using Write (rs.%Display()) it gives me below result but (rs.%Get("Prefix")) method give me null value.
Please help