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

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!