Devart Forums

Hi,

Is it possible to display a (wide)memo as a (wide)string?

I do not like (MEMO) or (WIDEMEMO) as the text, is it an option somewhere, I cannot find it?

Most other componentsets display the blob string as normal data.


Thanks.

There is no such option.

@upscene: depending on your RDBMS, you could do an explicit type conversion within your SELECT with the CAST function.
Example for MS SQL Server to add a new column ("mymemo" being the original "TEXT" column):

SELECT mymemo, CAST(mymemo AS VARCHAR(200)) AS MemoString
FROM mytable

Then just use the new column "MemoString" in your grid (read-only), which should be detected as regular TStringField.

Hello Tobias,

Thank you for the suggestion, but I'm unable to modify SQL statements like that

However, what I can do, is using the TField event to display the string, that could help as well.