How can I get the SalesLogix Notes/History LongNotes field to display in a datagrid??

Question:

I want to display some values in datagrid. I was able to retrieve every value except the database column with a TEXTBLOB datatype for LongNotes. I get some errors..Do you have any other solution?

Answer:

One trick is to use your own SQL and cast the memo field as say VARCHAR(2000) and display that in the grid

select cast(longnotes as varchar(2000)) longnotes from HISTORY