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


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?



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!