Re: Re: Newbie with lots of questions

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 <[email protected]> wrote:
> Ross Johnson <[email protected]> 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
> [email protected]
> 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