Hi Manolis,
> I always get an error with forms that contain subforms:
>
> "The data content could not be loaded."...
>
> SQL Status: 42000
> Error code: 1064
>
> 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_idfield )' at line 1
Ah .... MySQL does not recognize named parameters (":link_from_idfield",
in your case). The existing driver works around this by replacing named
parameters with unnamed ones ("?"). The native driver does not do this, yet.
One more for the list at
http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native.
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]
