DBGrid question: Columns & Headers
lazarus / 16-Databases

----------------------------------------------------------------------
IPguy · 2012-01-13 02:59

Two questions (probably having the same solution)

1) Is it possible to not show some of the DBGrid columns?
Every time I do a select * from ..., all of the columns show up.
Do I need to follow the above stmt by a set of 
DBGrid1.Columns.Items[1].Visible statements?

2) How do I change the name of the DBGrid column header titles (the
one's the customers see on the screen)?  After every select *, all of
the columns show up with the DB names and I would like to display
presentable names.
Do I need to follow every select * ... with a set of commands to
rewrite the headers?

I found a hint to double click on the SQLQuery1 object and to enter
the names there, but when I try that, I get the message: "It was not
possible to get the dataset field's list.  Check dataset settings. 
Access Violation".

0.9.31-34510-2.5.1-win32-Vista, Firebird embedded

----------------------------------------------------------------------
goodname · 2012-01-13 03:18

Double click on the DBGrid. This will bring up a window where you can
edit the order, datasource, and title of each column.

----------------------------------------------------------------------
Mando · 2012-01-13 10:59

Hello:

Quote1) Is it possible to not show some of the DBGrid columns?
Every time I do a select * from ..., all of the columns show up.
Do I need to follow the above stmt by a set of 
DBGrid1.Columns.Items[1].Visible statements?
If you know the columns you want to show, you can define those in the
columns designer accessible via objet inspector (columns property) o
via double-click on DBGrid.

Quote2) How do I change the name of the DBGrid column header titles
(the one's the customers see on the screen)?  After every select *,
all of the columns show up with the DB names and I would like to
display presentable names.
Do I need to follow every select * ... with a set of commands to
rewrite the headers?
In the same manner.