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!
|
|
Displaying a Memo data type in a grid
Posted: 05 Mar 08 11:43 AM
|
| Is it possible to display data stored with a field type of Memo? I thought I might get lucky using the vb Right function in a calculated field so I could pull the data and display it, but when I am in Manage Calculated fields I am unable to drag the field into the calculation area. |
|
|
|
Re: Displaying a Memo data type in a grid
Posted: 06 Mar 08 12:53 AM
|
Hi Bill
As far as I know, the standard SLX datagrid control cannot handle memo fields. The way around that is to have another String field on the same record, that is displayed instead. Put a hidden edit box on the screen wherever that memo field is displayed for editing. On the memo box, put an OnChange script on that memo box that copies the left-hand so-many characters from the memo field into the hidden edit box. Then, just make sure that edit box is bound to the string field.
That's how Sage has done it on the History table, with short_notes (string) and long_notes (memo).
Hope that helps.
Alternatively, go buy a more powerful ActiveX control and deploy that instead. Someone clever out there in developer-land (Hi RJ and Ryan!) will know where to buy those from.
Regards from sunny Brisbane, Australia
Paul |
|
|
|
Re: Displaying a Memo data type in a grid
Posted: 06 Mar 08 8:05 AM
|
Hi Paul!
An alt is to go to the Columns property and change a setting there (can't remember exactly what is ie.. - datatype?.. ) and it will let you used the in place "editor" to pop up the info.
But the way notes-history does it (and tickets stuff too) is probably the best way.
--
RJLedger - rjlSystems |
|
|
|
Re: Displaying a Memo data type in a grid
Posted: 06 Mar 08 8:29 AM
|
Thanks Paul,
I never thought of doing that. I have everything in place and it is working great. Now all I need to do is write the update scripts to get the existing data populated in the hidden text field I added. |
|
|
|
Re: Displaying a Memo data type in a grid
Posted: 06 Mar 08 12:31 PM
|
You should be able to do this v6.2 and higher.
Go into the Column properties and set type = Memo
Then go into properties and set the blob style to be text.
ws |
|
|
| |
|