By the way, I didn't bother including it because I figured my code is probably completely wrong from the ground upAlways attach a demo project, otherwise we just shot in the dark, it does not matter if it's wrong or not and don't worry we all make mistakes.
Halp pleaseHere you go:
Does the same happen with a "regular" DBGrid?
@heebiejeebiesQuoteBy the way, I didn't bother including it because I figured my code is probably completely wrong from the ground upAlways attach a demo project, otherwise we just shot in the dark, it does not matter if it's wrong or not and don't worry we all make mistakes.QuoteHalp pleaseHere you go:
- download then extract attached project
- copy sqlite3.dll to your project folder, make sure the bitness is correct depending on your Lazarus/FPC version
- compile/run project
PS: Please note that I never worked with KControls and KDBGrid in particular, maybe there are better ways to achieve the same thing.
Does the same happen with a "regular" DBGrid?
That was another option that I tried, which again resulted in lots of lost hair. Basically I couldn't get a regular grid to load the data, it just showed (MEMO) in all the cells.
Does the same happen with a "regular" DBGrid?
That was another option that I tried, which again resulted in lots of lost hair. Basically I couldn't get a regular grid to load the data, it just showed (MEMO) in all the cells.
And if you've just searched the Forum, there are enough answers for the "(MEMO)"-Thing for DBGrid in combination with SQLite....
The easiest being
SELECT CHAR(SomeTextColumn) AS Field1 FROM SomeTable