syntax error(missing operator) in query expression when using delphi and ms access

Question

Does anyone know the source of this error:

project xxxx.exe raised exception class EoleException with message 'syntax error(missing operator) in query expression 'serial number=?'

this is my actual code in delphi with ms access database.

with AddIndividualsAccountADOQuery do
begin
  SQL.Clear;
  SQL.Add('Select * from IndividualAccount where Serial Number=:Sno');
  Parameters.ParamByName('Sno').Value:=edit1.Text;
  Open;
  Active:= True;
end;

the actual code runs well with delphi and sql database. but when i use ms access, the above error results when i run the application.

Mark Wilkins · Accepted Answer · 2013-01-30 22:57:52Z

7

I believe with MS-Access you need brackets around the name (since it contains a space):

Select * from IndividualAccount where [Serial Number]=:Sno

answered Jan 30, 2013 at 22:57

Mark Wilkins

41.3k5 gold badges61 silver badges111 bronze badges

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

Collectives™ on Stack Overflow

syntax error(missing operator) in query expression when using delphi and ms access

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related