Oracle and DBGrid

[blindkangaroo]

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]

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.