Base does not allow editing mysql result on table join

Hi there!

First, let me say I’m impressed by all Base can do, it’s amazing to have so little to do to program interfaces =)
There’s one thing I’d need to find a solution though!

It’s easy to do a query and to edit the result.
However, if I do a simple JOIN between tables, making sure I keep the foreign keys in the result:

  • if I use the embedded hsqldb driver, the result is editable
  • if I use the JDBC mysql driver, the result is not editable

And I would really need this thing!

So far, I tried the advanced driver options, checked if there are custom driver options, etc. Checked if I can define the table in a different fashion. I’m currently trying firebird because of this.

Any help would be greatly appreciated! =D

Laurent