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