/Delphi/INSERT into syntax error in delphi

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;

Source: stackoverflow.com

Similar codes

0 vote273 views1 answer
Duplicate ' in string delphi
Delphi
0 vote206 views3 answers
Delphi keypress ctrl+v
Delphi
0 vote244 views1 answer
How to make a shape move in delphi
Delphi
34 votes438 views2 answers
Shuffle list and print
Delphi
0 vote283 views1 answer
Delphi copiarcaracter string
Delphi
0 vote216 views1 answer
Bootstrap 4 form modal popup
Delphi
0 vote215 views2 answers
Remove escapes from json
Delphi
0 vote221 views1 answer
React replace object in array
Delphi
2 votes425 views1 answer
Delphi how copy works
Delphi
0 vote220 views1 answer
How to use incyear in delphi
Delphi