Removing (MEMO) in DBGrid
lazarus / 16-Databases

----------------------------------------------------------------------
egsuh · 2020-02-29 13:49

The Lazarus Reference Manual says, we can remove '(MEMO)' as following
way:

QuoteExample: Avoid displaying text fields as "(Memo)" for DBGrids

When you use SQL statements like "Select * from A" you might see
"(Memo)" instead of your content in a grid cell. There are many ways
to fix this, but maybe the easiest is to change your statement "Select
* from A" to "Select Cast(Column as TEXT) as Column from A". This is a
common problem when you use a DBGrid component.
as explained at

https://wiki.lazarus.freepascal.org/Grids_Reference_Page#Multilines_in
_Grids

But, this does not work at least for PostgreSQL. Instead,

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i Select
Cast(Column as varchar(40)) as Column from A
works.  I haven't tried with other databases. Is this kind of bug or
does this depend on database brand?