<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18999">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>I have an sql query. I have two db Grids on my form, one
from the table and the other a query from the same table with conditions.
<BR><BR>The dbgApp is a standard db grid and the dbgQApp is a query on the table
App. It all works correctly until I modify the query columns properties.
<BR><BR>If I use the Column editor or a line of code, I get an empty query grid.
<DIV><FONT size=2 face=Arial></FONT> </DIV><FONT size=2 face=Arial>
<DIV><BR>procedure TfDiary.FormShow(Sender: TObject);<BR>begin<BR>
dm.qApp.Close;<BR> dm.qApp.SQL.Text:='Select
ID,Dat,DOW,Type,Summary,Status,DatComp from App Order by 2';<BR>
dm.qApp.Open;<BR> dbgQApp.Columns[0].Visible:=False; // Hides
the whole table. Incorrect <BR>
dbgApp.Columns[0].Visible:=False; // Hides the first Column.
Correct<BR> end;</DIV>
<DIV> </DIV>
<DIV>Is there an order in which this has to be done for it to work
correctly?<BR><BR>Thanks Wallace </FONT></DIV></BODY></HTML>