/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 vote179 views2 answers
Eval javascipt
Delphi
0 vote178 views1 answer
Inputbox delphi
Delphi
0 vote217 views1 answer
How to insert apostrophe in delphi string
Delphi
0 vote189 views1 answer
How to validate if the text in edit has numbers in and to show a message if it has in delphi
Delphi
0 vote220 views1 answer
Duplicate ' in string delphi
Delphi
4 votes150 views1 answer
How to find the length of a string delphi
Delphi
0 vote154 views1 answer
How to end a program in delphi
Delphi
0 vote178 views1 answer
Bootstrap 4 form modal popup
Delphi
0 vote175 views1 answer
Choose character from string in delphi
Delphi
34 votes278 views2 answers
Shuffle list and print
Delphi