Forum > LCL

SQLite - DBGrid - text field is memo

(1/2) > >>

Milsa:
I connected to SQLite database and set SQLQuery. Output is in DBGrid. Text field I see as "(Memo)".

This isn't for Lazarus, because I can't define events for GetText in IDE (fields haven't events):
http://stackoverflow.com/questions/4809298/lazarus-dbgrid-showing-memo-as-the-value-of-string-fields-in-sqlite-3

This tutorial is not about reality (memo problem isn't there :o ):
http://alevel-computing.x10.mx/mw/index.php/Tutorial_DBGrid

How can I fix this problem? I want to see text from database.

BigChimp:
Answered already on the forum and the wiki page on grids...

Milsa:
Thank you very much. I searched with Google and I found wiki grid reference page but it didn't help me. After your reply I found with search on this forum this thread http://forum.lazarus.freepascal.org/index.php /topic,19339.msg110012.html#msg110012 with solution. Then I found it in grid reference page. Please add information about SQLite and memo to this wiki page for Google and add GetText procedure (solution is not complete on wiki page).

BigChimp:
If you miss info on the wiki, you're welcome to add it.

ddimov007:
Old thread, however, it might be helpful to elaborate on the discussion above. The link in question above that can help fight the issue of having no GetText event on DBGrid is:

http://forum.lazarus.freepascal.org/index.php/topic,19339.msg110012.html#msg110012

It works!

Navigation

[0] Message Index

[#] Next page

Go to full version