MySQL supports foreign key constraints with their innodb system I
believe. MyISAM doesn't support foreign key constraints
(relationships) iirc.
Sam
On 5/19/06, Seb <spluque@xxxxxxxxx> wrote:
Ross Johnson <Ross.Johnson@xxxxxxxxxxxxxxx> wrote:
[...]
> I've found OOo Base together with PostgreSQL via the PostgreSQL.org
> JDBC3 driver works very well. Whichever database you choose, most/all of
> the GUI Query Designer works as does the Forms designer, or you can
> write pass-through queries to access database-specific features if you
> want. I've just completed a large job using these components building an
> application that includes over 800 form controls spread over a dozen or
> more forms. I used mdb-tools to migrate the Access data to PostgreSQL.
Thanks for the corrections, OOo Base seems to have come a long way since I
last delved into this. Sounds as if it's worth a try for sure!
I don't know how PostgreSQL works, as I've already chosen MySQL some time
ago, but were you able to migrate your Access relationships? If you were,
could you please point out the procedure, if it's not a hassle?
I was able to migrate all my Access tables to MySQL with mdb-tools, but
had to reconstruct relationships on a per-query basis afterwards. I'm
still learning MySQL, so I'm not even sure it supports a system of
relationships in the sense that Access does.
--
Seb
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
mdbtools-dev mailing list
mdbtools-dev@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642
|
