Hi Thiemo, > I tried with great interest your extension for MySQL. It worked and it > seems to be faster than JDBC which I used before. However, when trying > to open a form including a subform (created entirely with the form > assistant, nothing fancy), I get the following message: > > You have an error in your SQL syntax; check the manual that corresponds > to your MySQL server version for the right syntax to use near > ':link_from_id )' at line 1
Thanks for your interest in the driver's preview release, and your feedback. The concrete problem you describe is known, and listed here: http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native. It will be fixed before the final release. > I have no idea where that link_from_id comes from, neither do I know how > to access the SQL code that is used by the form. The parameter field named "link_from_id" is auto-generated, it indicates you connected your master and sub form specifying the columns in which they're joined, and of of those columns is named "id". Thanks & Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
