k Ratliff wrote:Hello,
I am trying to import records from one database to another database locally when a user presses a JButton. I followed the solution provided by Jan and everthing executes fine, however, it is only inserting one record into the second database and then does not execute after that and I get a SQLException:General Error. I am not sure that I am looping thru the result set correctly.
Here is what I wrote based on Jan's suggestion.
what if you have 50 or more columns how would you do it?