Ocke Janssen wrote:
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..
I will try a query over at the MySQL site then. See if I am missing
something on the J/Connector settings. I did try this, just FYI with
both the ODBC and JDBC drivers
and I think it's latest stable, JDBC driver, 3.18.
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 ;-)
At my last corporate job I had to field requests from large customers
for enhancements that THEY had to have...my response was often ...would
you like to talk about a client funded initiative..and then show the
fully loaded coast of a software engineer man month (Fully loaded
meaning with the cost of support, doc, qa and mgmgt added in)...usually
made them think twice.. :-$
From what I have read so far just getting the build environment setup
on my machine is gonna be a barrell of fun. :-!
I will take a look and if I am not totally lost I will try. Expect lots
of questions (mostly dumb ones) from me as I go, OK.
Best regards,
Ocke
Thanks
Andrew Jensen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
