* * *

Author Topic: SQLite - DBGrid - text field is memo  (Read 7258 times)

Milsa

  • Full Member
  • ***
  • Posts: 165
SQLite - DBGrid - text field is memo
« on: September 24, 2013, 03:51:40 pm »
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

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: SQLite - DBGrid - text field is memo
« Reply #1 on: September 24, 2013, 04:04:30 pm »
Answered already on the forum and the wiki page on grids...
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

Milsa

  • Full Member
  • ***
  • Posts: 165
Re: SQLite - DBGrid - text field is memo
« Reply #2 on: September 24, 2013, 04:47:12 pm »
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

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: SQLite - DBGrid - text field is memo
« Reply #3 on: September 24, 2013, 04:55:54 pm »
If you miss info on the wiki, you're welcome to add it.
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

ddimov007

  • New member
  • *
  • Posts: 5
Re: SQLite - DBGrid - text field is memo
« Reply #4 on: March 08, 2017, 12:13:10 pm »
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!

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus