How to correct this behavior?
In you select statement do this for column that behaves like this in dbedit:Code: Pascal [Select][+][-]SQL.Text := 'select ..., cast(your_column as varchar(50)) as your_column, ... '
Why use tDbEdit on a memo field, use tDbMemo instead.
If a tdbedit or tdbgrid shows ‘Memo’ it usually means that the source field in the database is a memo field. Have you tried replacing the tdbedit by a tdbmemo, just as a test?
Quote from: JanRoza on March 17, 2023, 05:28:08 pmIf a tdbedit or tdbgrid shows ‘Memo’ it usually means that the source field in the database is a memo field. Have you tried replacing the tdbedit by a tdbmemo, just as a test?He‘s probably using SQLite, and it‘s a known issue with DBGrid for SQLite text columns that the grid thinks it‘s memo instead of plain text