[bug_fixed] MySQL: Cannot update this query type(backticks)

[AHUser]

If I specify this SQL select:

Code: Select all

select * from TableName

there is no problem in editing the records.

But if I use the quotation chars for the table name:

Code: Select all

select * from `TableName`

I get the error message "Cannot update this query type".

svn branch/testing (MySQL)

[mdaems]

Hi AHUser. Before I start debugging my modification, can you please confirm it's only happening for temporary tables?
Sounds like a more general problem with quoting. Which of course should also be fixed but that requires some more time for an unexperienced zeos/delphi coder as I (really) am, I'm afraid.

Mark

[IgD]

Why would you want to put the table name in quotes? I've read several MySQL books and even the MySQL docs and never seen a SQL Query like that. I vote using quotes for the tablename is improper syntax.

[mdaems]

Hi AHUser,

I recently fixed this problem with backticks (Igd, that's because mysql allows spaces in tablenames). Unfortunately it didn't make it before the beta release. You can check it in SVN testing branch if you want.

Please report when it works. I didn't get confirmation from the other reporter yet.

Mark

[domi.papin]

Hello,

Tested with latest svn testing branch. Backticks are ok for me, now.
Thanks for fixing that Mark.

Dominique