Re: Checking Multiplicity Constraints and Retrieving Details from Error Messages

2005-10-19 Thread Ledina Hido
On 19 Oct 2005, at 20:30, Jochem van Dieten wrote: On 10/19/05, Martijn Tonies <[EMAIL PROTECTED]> wrote: First of all, is there any way of limiting the number of rows in a table, referencing to the same element of another table? For example, force a manager not to have more than 10 empl

Re: Checking Multiplicity Constraints and Retrieving Details from Error Messages

2005-10-19 Thread Ledina Hido
On 19 Oct 2005, at 15:58, Martijn Tonies wrote: Second, is there any way of getting more details out of an error message? So for example, when doing a bulk upload to the database, rather than just getting "Cannot add or update a child row: a foreign key constraint fails" I would like to know

Checking Multiplicity Constraints and Retrieving Details from Error Messages

2005-10-19 Thread Ledina Hido
As part of my 4th Year Group Design Project, I am required to build a database system that will validate and then store the data. As such I am currently investigating different DB, to choose the most suitable one. I like many features of MySQL but there are a couple of things I am not very