Zeoslib Portal

In MySQL, I can select a table in two ways: "select * from a_table", or "select * from `a_table` “.
The difference between them is the second way cannot be updated using a DBGrid.
But if I use a reserved word as table name ,I must use the second way, or I cannot open the query.
So how can I update the query like the second way? Like "select * from `character` ".

Thanks a lot !

If I use a TZTable to open "character" table, the TableName property must be `character` too, so it still cannot be updated when I'm using DBGrid.

:-(

Hi,

Can you please try with one of the SVN snapshots? (see beta release announcement on the portal for a link)

This problem has been mentionned before and I did write a patch for that. Unfortunately it was not in time to get into the beta release yet.

Mark

Oh, thank you very much!

Thanks Mark, I've tried the latest build, it works!
Thanks very mych!