Hi Andrew,
Andrew Jensen wrote:
Actually this is two questions?
Using MySQL the Relationship dialog in Base will not open stating that
Realtionships are not supported for this
database. Now, using MyISAM I can understand this, but if the MySQL
server has been configured to use InnoDB
engine as the default then it does support foerign keys. Should not
the relationship dialog open in this scenario?
We ask the driver if he returns true for the method
XDatabaseMetaData::supportsIntegrityEnhancementFacility. If not you'll
see the error dialog.
I don't know if there is a driver available which supports or just
returns true. :-) We could add an extra entry for this case as we've
done for many other
properies we have to ha..
Second question - Again with MySQL, Are there any plans to allow the
user to select which engine they want
a table definition to use, when the server supports multiple engines?
MyISAM, InnoDb, BDB on MySQL for example.
Yes, this a good idea as well. The first shot could be toset the type
via a property of the data source settings.
The next step then should be to show it in the UI. If you want to try it
:-) the source is in connectivity/source/drivers/mysql/YTables.cxx
and connectivity/source/commontools/dbtools2.cxx
createSqlCreateTableStatement
Every help is welcome ;-)
Best regards,
Ocke
Thanks
Andrew Jensen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Sachsenfeld 4 mailto:[EMAIL PROTECTED]
D-20097 Hamburg http://www.sun.com/staroffice
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
