INSERT into syntax error in delphi
ADOquery1.SQL.Add('Insert into admins');
ADOquery1.SQL.Add('([Name] , [Surname], [Dateadded], [Adminnumber], [Password])');
ADOquery1.SQL.Add('Values (:Name, :Surname, :Dateadded, :adminnumber, :Password)');
ADOquery1.Parameters.ParamByName('Name').Value := edit11.Text;
ADOquery1.Parameters.ParamByName('Surname').Value := edit12.Text;
ADOquery1.Parameters.ParamByName('Dateadded').Value := edit13.Text;
ADOquery1.Parameters.ParamByName('Password').Value := edit14.Text;
ADOquery1.Parameters.ParamByName('Adminnumber').Value := edit15.Text;
ADOquery1.ExecSQL;
ADOquery1.SQL.Text := 'Select * from admins';
ADOquery1.Open;
Are there any code examples left?
New code examples in category Delphi
-
Delphi 2022-03-27 19:40:03 delphi keydown enter
-
Delphi 2022-03-20 03:25:01 get time in milliseconds delphi
-
Delphi 2022-03-16 18:50:01 delphi random letter
-
Delphi 2022-02-14 03:45:08 remove unnecessary packages raspi pixel
-
Delphi 2022-02-02 21:15:46 delete in delphi
-
Delphi 2022-01-23 12:15:39 pyhton instagram bot
-
Delphi 2022-01-23 09:05:59 delphi calculator
-
Delphi 2021-11-21 18:31:10 download jupyter for linux
-
Delphi 2021-11-20 04:57:08 copy delphi