i am creating a tableA with a few records in one connection. With another connection i am inserting all the records from tableB into tableA
In short i append the tableA with tableB using the execute statement below.
st2.executeUpdate("insert into FormulaQ1Q2 select * from FormulaQ1")
The prblem is not all the records are being inserted. After appen i should have 2000records. I am only having 1923 records. Please let me know what is the problem? [ April 23, 2008: Message edited by: catherine matthews ]
I am using Jackess to copy the tables. As i copy The first tableA i have the correct amount of records. After i copy the second Table. The records in the first table gets changed. I loose 4 records. And the number of records in tableA becomes lesser. This is my method to copy the table. I am using the same method. Changing the variable for the Connection. Please let me know why this wierd thing is happening
[ April 24, 2008: Message edited by: catherine matthews ]
subject: not insering all the records (please help!!)