How can I update this type of tables?

lyphard · Post by **lyphard** » 12.12.2006, 07:52

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 !

lyphard · Post by **lyphard** » 12.12.2006, 07:58

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.

:-(

Post by **mdaems** » 12.12.2006, 10:46

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

lyphard · Post by **lyphard** » 12.12.2006, 14:24

Oh, thank you very much!

lyphard · Post by **lyphard** » 12.12.2006, 14:40

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