Hi John Hint: it's always a good idea to give names to your constraints and suchlike, so that the error message will refer to a name that appears in your DB schema, rather than a system-generated name like SQL170412104646890. If you can't figure out which is the violated constraint referred to in the error message, you might have to dig around in SYS.SYSCONSTRAINTS to identify it.
You are way above my head here :) Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147409.html Sent from the Apache Derby Users mailing list archive at Nabble.com.