read from database

[skaner1900]

The question like in the subject. First: I've got the database with text, integers and dates, and after sending the command SELECT I'd like to download the obtained result to the arrey of string variable or to a tabel component. Second: I'd like to download one selected line (SELECT FROM WHERE) to variables like string, integer and tddatetime
May you include sample source?

[Arbee]

I would suggest you start reading here: http://wiki.lazarus.freepascal.org/Databases
and take it from there.

[skaner1900]

hmm i downloaded MySql5Test, but

  ShowQueryForm := TShowQueryForm.Create(nil);
  try
    ShowQueryForm.DataSource1.DataSet := SQLQuery1; <----- This line reciving error: "File not open"
    SQLQuery1.ParseSQL:=true;
    SQLQuery1.ReadOnly:=false;
    SQLQuery1.SQL.Text := CommandEdit.Text;
    SQLQuery1.Open;
    ShowQueryForm.ShowModal;
  finally
    SQLQuery1.UpdateMode:=upWhereChanged;
    SQLQuery1.ApplyUpdates;
    SQLTransaction1.Commit;
    ShowQueryForm.Free;
    SQLQuery1.Close;
    SQLQuery1.ParseSQL:=false;
    SQLQuery1.ReadOnly:=true;
  end;   

and how to show results?
dbGrid1.DataSource:=SQLQuery1.DataSource; ??
it doesn't work...

so... i don't know how to download information from database but i can how use it next

[paweld]

http://wiki.lazarus.freepascal.org/Lazarus_Database_Tutorial#Simple_MySQL_Demo_Using_the_TMySQL50Connection_Component