Hi all,
The last couple of weeks I have been struggling with the creation of an administration program for a friends private company. The purpose of this program is to connect to an SQLite database, show the data of the people using a dbgrid and be able to add or delete files. However, I struggle to find a good guide and started using many different guides to get a result. I don't seem to find a solution on how to insert files into the database using Lazarus. The methods I tried are shown below. ( excuse me for my variables I am Dutch and for the enormous lines.)
SQLquery1.SQL.Add(Format('Insert into
IZHdata(Relatie_code,Achternaam,Voornaam,Geboortedatum,Straat,Postcode,Plaats,gsm,telnr,emailadress,aantal_behandelingen) values("%s","%s","%s","%s","%s","%s","%s","%d","%d","%s","%d")', [Edit1.text, Edit2.text, [/font]Edit3.text,Edit10.text,Edit4.text,Edit5.text,Edit6.text,Edit7.text,Edit8.text,Edit9.text,Edit11.text]));[/i]
SQLquery1.SQL.Add('Insert into IZHdata(Relatie_code,Achternaam,Voornaam,Geboortedatum,Straat,Postcode,Plaats,gsm,telnr,emailadress,aantal_behandelingen) values('+QuotedStr(Edit1.Text)+','+QuotedStr(Edit2.Text)+','+QuotedStr(Edit2.Text)+','+QuotedStr(Edit10.Text)+','+QuotedStr(Edit4.Text)+','+QuotedStr(Edit5.Text)+','+QuotedStr(Edit6.Text)+','+QuotedStr(Edit7.Text)+','+QuotedStr(Edit8.Text)+','+QuotedStr(Edit9.Text)+')');
This is my first time on the forum so excuse me if I have created my post a bit messy.
Do you know a solution to this problem or could help me with a decent guide on SQLite and Lazarus?
Thank you for your help.
sincere,
JLommen