taariq

thanks - let me download and do a test database...
I am doing a Windows based program for my self - Job Card

So just to see if I understand Firebird
Download and install
Create database in Firebird
Use in Delphi

If I want to use program on another pc can I just like in Access copy the DB into correct folder and use or do I need to install something ells on that pc...
Thanks for all the reply's and help...appreciate it...

Thank you

Good day

How do I get started with Firebird ?
Please can you point me in the right direction....

Thank you

Thank you all so much - I will have a look and update now...Thank you
Just a question - what other databases will you advice me to use...

Thank you all - so nice to see Delphi live and well ...

Good day

Please assist, I am a newbie

I am trying to save data to an Access database...
Keep getting the following error
Syntax error in From clause

Code below

procedure TMainForm.b_save_new_recorsClick(Sender: TObject);
begin
dmTaS.query_JobCard.SQL.Add('Insert into JobCard(');
dmTaS.query_JobCard.SQL.Add('(ID ,OrderNo ,JobName)');
dmTaS.query_JobCard.SQL.Add('Values :ID :OrderNo, :JobName)');

dmTaS.query_JobCard.Parameters.ParamByName('ID').Value := lb_ID.Text;
dmTaS.query_JobCard.Parameters.ParamByName('OrderNo').Value := lb_OrderNo.Text;
dmTaS.query_JobCard.Parameters.ParamByName('JobName').Value := lb_JobName.Text;

dmtas.query_JobCard.ExecSQL;
dmTaS.query_JobCard.SQL.Clear;
dmTaS.query_JobCard.SQL.Text := 'Select * from JobCard';
dmTaS.query_JobCard.Open;

I added the following in the TADOQuery under SQL
 SELECT * FROM JobCard

Thank you