Written by

Question sansa stark · Sep 20, 2016

Query Method -Stream Property

Hi all,

         In CSP page we get data from Class via Query method.

         <TD valign=top>#(DEOBJ.Get("Comments").Read())#</TD>

         The problem is we couldn't get the stream property value.

        (Property Comments As %Stream.GlobalBinary)

Thanks,

sansa.

         

Comments

Eduard Lebedyuk · Sep 20, 2016

In the underlying SQL write

 SELECT SUBSTRING(Comments, 1, 100) As Comments, ... FROM TABLE

to get first 100 characters from the stream. More info.

0