slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: How can display memo control values in Datagrid? [VPC 2007]

Deepika
Posts: 14

How can display memo control values in Datagrid? [VPC 2007] Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Aug 10 5:20 AM

I want to display some values in datagrid.i got every value except memo control value.so i tried to get 'LONGNOTES' values in a separate memo controls like Notes-History.But i dont get the value and also showing some errors too..Do you have any other solution?

If anyone knows ,pls help me...

[Reply][Quote]

RJ Samp
Posts: 973

Re: How can display memo control values in Datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Aug 10 7:27 AM

Which version of SLX?

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

There's a reason that SLX puts 255 characters in the notes field....so you can easily display it in a grid. Or export it to Excel, say, 2000. Nowadays Excel can handle larger fields sizes, as can SQL, Access, et al.....but back in the day.....

[Reply][Quote]

Deepika
Posts: 14

Re: How can display memo control values in Datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 23 Aug 10 9:26 PM

I think you are saying about NOTES field.But i want to display LONGNOTES . Longnote is a memo control.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: How can display memo control values in Datagrid? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Aug 10 2:54 AM

Quote:

Originally posted by Deepika

I think you are saying about NOTES field.But i want to display LONGNOTES . Longnote is a memo control.

Actually, no. RJ Samp is suggesting something along the lines of

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

2000 characters is considerably longer than the 255 that NOTES provides, which you'd know if you'd taken the time to digest the contents of his message.

Longnotes is not a "memo control" either. It is a database column with a TEXTBLOB datatype.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/6/2025 8:47:02 AM