Hi Rick, John, Bryan et al Things are a *little* clearer now :)
I was a bit premature in stating that all was OK To try and rectify my problem (without understanding what was wrong) I changed the index in table2 from a single column (INT) to a 2 column index (DATE and TIME) exactly as Table1 was setup I then ran the program on a historical tester platform for a period of 3 months The end result was that it seemed to run perfectly - carrying out 54 new trades in that period It also told me that the number of records in table2 (TRADES) increased by 54 BUT, and it is a big *BUT* when I use Netbeans to view the data in table2 I see just the 4,100 records that existed when I initialized the setup i.e. I can not see the 54 new records ????? This explains why, in the past an error concerning duplicate keys came about - the error was correct but I could not see any new records (and still cannot) I am puzzled by this because to setup table2 I opened Netbeans, connected to the database I require - where I can see table1 and ran a file which set up table2 with 4,100 records Table2 then appeared and I could view the 4,100 records So my question is: why do I not see the new 54 table2 records that my program says have been created? Thank you Bob M New Zealand -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147442.html Sent from the Apache Derby Users mailing list archive at Nabble.com.