Syntax Error with Query

Question

I would like to use an Insert Into query in Delphi XE2 to insert a user's information into a MS Access Database. The problem is I keep getting the same error:

Syntax error in INSERT INTO statement

I have done some research but there is no definitive answer. my source code is:

  opendb('QuizDB.mdb');

  DB.Close;
  DB.SQL.Add('INSERT INTO tblUsers');
  DB.SQL.Add('(FirstName,Surname,Username,Password,Grade)');
  DB.SQL.Add('Values (:Firstname, :Surname, :Username, :Password, :Grade)');

  Db.Parameters.ParamByName('Firstname').Value := pFirstname;
  Db.Parameters.ParamByName('Surname').Value := pSurname;
  Db.Parameters.ParamByName('Username').Value := pUsername;
  Db.Parameters.ParamByName('Password').Value := pPassword;
  Db.Parameters.ParamByName('Grade').Value := pGrade;
  DB.ExecSQL;

QuizDB being the database name, DB being a ADOQuery component and then p(var) being variables received as parameters.

How do I make it work?

Gord Thompson · Accepted Answer · 2016-11-20 12:49:30Z

3

PASSWORD is a reserved word in Access so if you use it as a column name you must enclose it in square brackets.

Try this instead:

DB.SQL.Add('INSERT INTO tblUsers ');
DB.SQL.Add('(FirstName,Surname,Username,[Password],Grade) ');

edited Nov 20, 2016 at 12:49

answered Oct 8, 2013 at 18:35

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Benedict Ferguson Over a year ago

Thanks so much. IT worked all I needed to do was add those brackets.

Gustav Over a year ago

There must be close to a hundred questions regarding this trap.

Collectives™ on Stack Overflow

Syntax Error with Query

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related