Empty DBGrid...

[bungayst]

I've been spending a disproportionate amount of time trawling through the forum looking for an answer, this is a pretty simple (or at least it should be) example based on stuff I've done in the past with GAMBAS and VB and some tutorial code for FreePascal from SF. I'll keep hammering on it but sure would appreciate someone with more experience than me would have a peek at the attached project.


  I have connected to the server, executed SQL, and verified that there are 10 records in the Datasource, but the Grid remains quite blank.

Some particulars of my environment.
  Debian 6.0
  Lazarus 0.9.2.28-12 (from Debian repo)
  MySQL 5.0

[gato2707]

You should search better, maybe with Google

https://www.google.com.mx/search?client=ubuntu&channel=fs&q=connect+a+dbgrid+to+a+database+lazaruz&ie=utf-8&oe=utf-8&redir_esc=&ei=DK-CUcDuHIafrgGT9YDoDA

Try this

http://www.alevel-computing.x10.mx/TutorialSoftwareRevision2.php

[bungayst]

Yup, been there, done that. I've been through most of those and they were non-helpful. Results are being returned, just nothing gets in the grid. Have a look at the project source.

[geno]

Have a look at the project source.

The source code file (mysqlexample1.pas) was not included in your tar file.

  regards,
     geno

[bungayst]

Thanks for looking Geno! Here's the tarball, with the previously missing pascal source added.I had done a "Save Project As" and placed it in it's own folder.. the .pas file apparently didn't follow. The modified tarball attachment has been re-attached to the original posting.

[BigChimp]

Have you seen
http://wiki.lazarus.freepascal.org/SQLdb_Tutorial1
and
http://wiki.lazarus.freepascal.org/SQLdb_Tutorial2

They explain exactly how to set up a dbgrid.

[bungayst]

  Thanks BigChimp. Yes, I have seen these. I have the items connected as they are described and that's why I've been pulling my hair out.  As I said in the first post, the Datasource is getting results, I do see a record count, I do see field names, I have checked two ways, by looking at the Datasource directly

DataSource1.DataSet.RecordCount)

and by looking at the datasource as linked to by the grid

DBGrid1.DataSource.DataSet.RecordCount)

  Still nothing visible in the grid. *sigh*. Perhaps I am not seeing the forest for the trees, can you have a look at the project?

[geno]

Due to my personal limitations, I am having a bit of trouble with your example program; the form is not being displayed in the IDE.  I am certain it is because it is saved as a resource (.lrs) as opposed to a regular form (.lfm)  I assume it might be because you are using an older version of Lazarus (0.9.28); I cannot say because I am by no means an expert here. 

But, if I am not mistaken, the SQLQuery1.Close in the try..finally block may be your culprit; closing this would clear the grid.

  regards,
    geno

[bungayst]

  Spot on Geno. The grid never gets a chance to display the data before the result set is cleared. The sample code I used had that close in the try finally block. I'm going to upgrade to 1.0.8 on my Fedora 14 box and soldier on.
 
  Thank you very much for your insight. I look forward to being able to return the favor to others as I dust off my Pascal knowledge and update it to the OO environment of today.

[BigChimp]

  Thank you very much for your insight. I look forward to being able to return the favor to others as I dust off my Pascal knowledge and update it to the OO environment of today.

Glad it works, thanks for posting that and good luck learning