Oracle and DBGrid
lazarus / 16-Databases

----------------------------------------------------------------------
blindkangaroo · 2007-07-06 18:56

I'm a Lazarus newbie and database newbie really and I'm trying to run
an SQL query on an Oracle database but I can't get the results to
display in a DBGrid.

I have the DataSource DataSet as SQLQuery1 and the datasource for the
DBGrid as DataSource1. Here is the code to run the query.

Code: [Select]
procedure Tfrm_imsman_main.btn_searchClick(Sender: TObject);
begin
  OpenConnection(nil);
  SQLQuery1.Close;
  SQLQuery1.SQL.Clear;
  SQLQuery1.SQL.Text := 'select * from gve_products';
  ShowString(SqlQuery1.SQL.Text);
  SQLQuery1.Open;
  SQLQuery1.Close;
end;



Thanks for any and all help
Cheers,
B

----------------------------------------------------------------------
nelson777 · 2007-07-06 20:21

I think the better advice I can give u is to check the lazarus
database tutorials in the documentation Wiki.  I tried the link to
give u the exact address but the wiki is offline (I wonder why ?). So
I guess u have to wait a bit.