I had the same problem with relationships (lack of) with both ODBC and
JDBC. The set up I had was:
OS = vista
MySQL = 5.0.45
Ooo = 3.0.1
Java RE = 1.6.0_07
MySQL connector java = 5.1.7
MySQL connector ODBC = 5.1.5
Lost (well vista went "awol") my tables so can't provide repeatable
example - sorry.
But as I've never used relationships before I put it down to missing a
step / pushing the wrong button / using wrong menu and did what I needed
server side.......
Darren
Jurgen Gaeremyn wrote:
Hi,
I'm new to this mailinglist... so I'll start of introducing myself.
I'm Jurgen, age 35, from Belgium and mainly love Open Source, not
working in it professionally (though I convinced my boss into a few
small projects already).
I'm running Ooo.org 3.0.1 (build 9379) under Ubuntu Intrepid Ibex and
a JDBC connector voor de database connection.
I'm trying to edit a MySQL database, but I'm having 2 different
problems. I'll explain them both here:
*1. Can't create relationships between tables*
In the "Relationship Design" view, I can place all my MySQL tables...
but I can't get any connections. I tried dragging and dropping, I
tried using the "New Relation" button.
Somewhere I read that Relationships are possible between MySQL tables
since Ooo.org Base 2.4
I'm not succeeding. What am I missing?
*2. Can't find the alternative for the SQL type ENUM*
I have a table with this kind of SQL field:
`cycle` enum('A','B','C','O','E','F','0') NOT NULL default '0'
Under Base, this gives me a field of the type "Text (fix) [ CHAR ]"
but I can't seem to figure out where I can edit or add the possible
values for the enumeration...
Thanks in advance for helping me!
Jurgen.
---------------------------------------------------------------------
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]
