Syntax error(missing operator) in query expression when executing update query

Question

I seem to have a problem with an Update query, I'm trying to use it to update a user's current details in a MS Access database using Delphi XE2. I asked a question previously and got help on the reserved word but now I seem to have another error with this query. The error is :

Syntax error(missing operator) in query expression '?
Surname=?
Username=?
[Password]=?
Grade=?'

That is the error I keep getting Below is the coding I have done:

procedure TUser.UpdateUser(pFirstname, pSurname, pUsername,
  pPassword: String; pGrade, pID: Integer);
var
  sSQL : String;
begin
  opendb('QuizDB.mdb');

  DB.Close;
  DB.SQL.Add('UPDATE tblUsers SET');
  DB.SQL.Add('Firstname=:Firstname');
  DB.SQL.Add('Surname=:Surname');
  DB.SQL.Add('Username=:Username');
  DB.SQL.Add('[Password]=:Password');
  DB.SQL.Add('Grade=:Grade');
  DB.SQL.Add('WHERE ID=:ID');

  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.Parameters.ParamByName('ID').Value := pID;
  DB.ExecSQL;
end;

Where DB is an ADOQuery component, ID is the primary Key in the database and unique to each record. TUser is my class I have created as a object.

Please Help me sort this out.

Have you seen this: http://dev.mysql.com/doc/refman/5.0/en/update.html and comma delimiter? — pf1957
– pf1957, Commented Oct 9, 2013 at 15:31
MySQL is not the same as MS Access. Please use the tags that are appropriate to your question instead of just adding anything that is similar. It helps properly organize the questions, and makes their presence known to people who might help you — Ken White
– Ken White, Commented Oct 9, 2013 at 15:37

kobik · Accepted Answer · 2013-10-09 16:12:18Z

3

please use Comma in SQL add lines:

DB.Close;
DB.SQL.Add('UPDATE tblUsers SET');
DB.SQL.Add('Firstname=:Firstname,');
DB.SQL.Add('Surname=:Surname,');
DB.SQL.Add('Username=:Username,');
DB.SQL.Add('[Password]=:Password,');
DB.SQL.Add('Grade=:Grade');
DB.SQL.Add('WHERE ID=:ID');

edited Oct 9, 2013 at 16:12

kobik

21.3k5 gold badges69 silver badges123 bronze badges

answered Oct 9, 2013 at 15:33

ikutluay

1421 silver badge9 bronze badges

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

4 Comments

kobik Over a year ago

@Alladinianת I think he got the right answer here. a sample would be nice thought.

ikutluay Over a year ago

@Alladinian thx for warning, but it is the answer... I ll just be care about include a code block for the be a sample of subject..

ikutluay Over a year ago

@kobik thanks for editing. I'll be carefull answering like this kind in future.

Alladinian Over a year ago

@kobik I guess it's fine now so I have removed the comment, thanx for the heads up

Collectives™ on Stack Overflow

Syntax error(missing operator) in query expression when executing update query

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related