Re: cannot get foreign keys to work

2003-01-10 Thread Alan Hodgkinson
Dear Ben, > i have been using the following sql to try and get foreign keys > working, the table creation works fine but when i try and delete data > from the parent table it deletes as would normally happen in mysql, > also the desired results do not happen if i use RESTRICT. > is this a problem

Re: Extracting foreign key info via ODBC (via JDBC)

2002-12-20 Thread Alan Hodgkinson
> Mark Matthews wrote: > > > Alan Hodgkinson wrote: > > > > I would like to extract the meta data describing foreign key > > relationships using ODBC (actually in Java using JDBC). > > > > My current version of mySQl 3.23.49 does not s

Extracting foreign key info via ODBC (via JDBC)

2002-12-20 Thread Alan Hodgkinson
Dear All, I would like to extract the meta data describing foreign key relationships using ODBC (actually in Java using JDBC). My current version of mySQl 3.23.49 does not seem to support it. That is the methods DatabaseMetaData.getImportedKeys(...) and DatabaseMetaData.getExportedKeys(..) retu