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

In this forum all bug reports concerning the 6.x branch will be gahtered. You have the possibility to track the bug fix process.

Moderators: EgonHugeist, mdaems

AHUser
Fresh Boarder
Fresh Boarder
Posts: 12
Joined: 11.04.2006, 00:33

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

Postby AHUser » 29.04.2006, 18:23

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)
Last edited by AHUser on 29.04.2006, 21:07, edited 1 time in total.

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 29.04.2006, 20:19

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
Zeos Dev Team
Zeos Dev Team
Posts: 43
Joined: 15.10.2005, 07:18
Location: Okinawa, Japan
Contact:

Postby IgD » 02.05.2006, 10:27

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.

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 25.10.2006, 15:59

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
Fresh Boarder
Fresh Boarder
Posts: 13
Joined: 12.09.2006, 11:15

Postby domi.papin » 27.10.2006, 16:30

Hello,

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

Dominique


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 1 guest