Why does This SQL query give a syntax error

Question

I have the following procedure which is executed on a button click (button1). After being prompted to log into the database, delphi throws the the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''AlphaMc'

SELECT * FROM 'AlphaMc111'' at line 1'. Process Stopped. Use Step or Run to continue.

Here is the procedure:

procedure TMainWin.Button1Click(Sender: TObject);
begin
  ADOConnection1.ConnectionString := 'Driver={MySQL ODBC 3.51 Driver};
  Server=db4free.net;Port=3306;Database=inventmanager;User=******;
  Password=******;Option=3;';

  ADOConnection1.Connected := True;
  ADOQuery1.Connection := ADOConnection1;

  ADOQuery1.SQL.Add('SELECT * FROM ''AlphaMc111''');
  ADOQuery1.Open;
end;

juergen d · Accepted Answer · 2015-02-05 10:27:05Z

1

Don't use quotes to escape column or table names. Use backticks

ADOQuery1.SQL.Add('SELECT * FROM `AlphaMc111`');

Quotes are string delimiters.

answered Feb 5, 2015 at 10:27

juergen d

205k40 gold badges305 silver badges377 bronze badges

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

Comments

Sir Rufo · Accepted Answer · 2015-02-05 22:27:55Z

1

I think the Problem is the Query itself.

AlphaMc111 does not need to be quoted as it is a Tablename

Quoted strings are only needed for Textinput in SQL Syntax.

try

ADOQuery1.SQL.Add('SELECT * FROM AlphaMc111'));

edited Feb 5, 2015 at 22:27

Sir Rufo

19.3k3 gold badges47 silver badges79 bronze badges

answered Feb 5, 2015 at 10:29

BigM

6881 gold badge17 silver badges29 bronze badges

Comments

Rhys Jones · Accepted Answer · 2015-02-05 10:29:49Z

0

The MySql identifier quote character is the backtick, try

ADOQuery1.SQL.Add('SELECT * FROM `AlphaMc111`');

answered Feb 5, 2015 at 10:29

Rhys Jones

5,5361 gold badge25 silver badges44 bronze badges

Collectives™ on Stack Overflow

Why does This SQL query give a syntax error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related