ADO Display label in DB grid
Posted on 2004-04-12
HI I would like to know how do you change the display label of a field in the grid if your TADOQuery SQL are both declared in the codes instead of using components.
looking at the example below, the genre will display as GENRE, product_type will be display as PRODUCT_TYPE in my grid. How do you change it? do i have to declare the stringfields or tfields? I don't know how to do it. Please help.THANKS!
procedure TFrameProductBook.BitBtnCategoryLookUPClick(Sender: TObject);
var SQL :string;
SQL := 'select genre, category_id from category, product_type';
SQL := SQL + ' where product_type = ''B''';
SQL := SQL + ' order by :order';
with FormCategoryLU do
QryLU.SQL.text := SQL;