Hi,
I've been through all the examples, forums, web pages, sites and references
I could find.
I'm working with MySQL 5 and OO Base 2.0.2, in XP, trying to get to a point
of using (3) table, many-to-many relationships with forms through
transaction tables and continuing to find that Base does not want to
recognize relationships or provide cascading updates and other features
associated with referential integrity, joins, etc.
MySql states that while they don't have an integral row management process,
nonetheless if each table has a unique ID and/or a "where clause" providing
direction, that the facilities for cascade and other relationships does work
and is discernable. Earlier references state it is a documented limiation
of typ IV Java Driver. I guess one proof is that DbVisualizer, using the
same driver, is able to decode and match relationships of primary and
foreign keys, relationship links and document them via the Java MySQL driver
as well as delivering query results that utilize cascades, etc, so why
shouldn't OO be able to do this as well?
I'm using com.mysql.jdbc.Driver, version 5.0.5, from the MySQL website,
mysql-connector-java-5.0.5-bin.jar
I only get back an error message under Tools > Relationships that says:
"The Database does not support Relationships",
But MySQL does support relationships, so is this error mal formed?
Has this been solved and I'm doing something wrong in driver permissions?
Is there a workaround besides hard-coding updates by Macro or other?
Is there a solution planned in the future, if there is no present solution?
Thank you,
Mike
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
