Query Method -Stream Property

CSP, Object Data Model, Caché

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.

         

  • 0
  • 0
  • 146
  • 1
  • 1

Answers

In the underlying SQL write

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

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