I really love the ability to be able add a nice simple error code / message to a foreign key constraint. Its already saved me a lot of work.

Most of the tables I have are On Delete Restrict so I use the message to simply inform the user that the record can't be deleted as it has child records - perfect.

The situation it creates though is that this error message applies both to restricting deletes, and to primary key violations. So if the primary key is violated I tell the user the record can't be deleted because it has child records. which is somewhat confusing

I mostly prevent violations before they occur....mostly.

I am assuming there is nothing I can do here, its just the way it works - just checking thats the case.

Chris,

<< I am assuming there is nothing I can do here, its just the way it works -
just checking thats the case. >>

There's an existing enhancement request from Barry about adding the ability
to use formatting and string substitution in the constraint messages, so
that should be able to get you what you need when it is implemented.

Tim Young
Elevate Software
www.elevatesoft.com

<<There's an existing enhancement request from Barry about adding the ability
to use formatting and string substitution in the constraint messages, so
that should be able to get you what you need when it is implemented.>>

That's perfect. Look forward to it. Thank You

Chris.