Control for listing Records?
lazarus / 21-General

----------------------------------------------------------------------
OC DelGuy · 2021-01-04 05:27

What would be the control I need to use to list database records?
I have a list if Items.  Each of those items has a description, level,
price and quantity.

I'd like to list these in a control that I put on the form.  But which
one do I use?

There's a tab called "Data Controls" in the Lazarus IDE.  Is this what
I'm looking for?  Do I use a TDBListBox?

----------------------------------------------------------------------
dseligo · 2021-01-04 06:41

You need DBGrid (second icon from the right side in your screenshot).

You also need a DataSource component (connect it to DBGrid and connect
it to TTable or TQuery component). TDatasource is in "Data Access"
tabl.

Here are links to more detailed tutorials on wiki:
https://wiki.freepascal.org/SQLdb_Tutorial1
https://wiki.freepascal.org/Lazarus_Database_Overview

----------------------------------------------------------------------
marcov · 2021-01-04 10:45

Note that there are also simple database examples in
lazarus\examples\database directory

----------------------------------------------------------------------
wp · 2021-01-04 11:26

It depends what you want to do, how your data are stored, etc. Just to
display a list of items I would not necessarily activate database
machinery. Use a TStringGrid, iterate through your list and add the
items successively to the grid.