OK John I have reinitialized the data in table1, table 2 remains static.
After the program has run for 2 times I should have the usual error about a duplicate key in table2 Exactly what would you wish me to post? Bob M p.s. the 2 tables are independent -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147424.html Sent from the Apache Derby Users mailing list archive at Nabble.com.