As Rob says, that first one should have thrown an exception. The fact that you mention it suggests that you're suppressing any exceptions you get (e.g. a catch block that does nothing). If that's the case, fix it, because it's possible your second example is also throwing an exception.
For instance, one thing I can think of that would cause it is a unique constraint on that table for one of the fields you're adding.
Joined: Aug 09, 2012
I would like to copy the same recordset in the same table .... with a selection to the JList
If the table you're trying to insert data into contains primary key(s), then an exception is thrown when trying to do this, because you're trying to insert another row with the same key; make sure you catch that one. Other thing might be that the SELECT does not return any rows, so no rows are inserted either.
paul beppe wrote:yes....i have result in my select!!!
Relax dude, people are trying to help you.
The quieter you are, the more you are able to hear.