How to correct this behavior?By searching the Forum first....
In you select statement do this for column that behaves like this in dbedit:Thanks, I'll try.
SQL.Text := 'select ..., cast(your_column as varchar(50)) as your_column, ... '
Why use tDbEdit on a memo field, use tDbMemo instead.I have a simple text field, not a memo.
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?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
You're right.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?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
In you select statement do this for column that behaves like this in dbedit:It helped, thanks.
SQL.Text := 'select ..., cast(your_column as varchar(50)) as your_column, ... '