Getting current row

jacq carballo

Ranch Hand

Posts: 42

posted 14 years ago

Hello All! After doing a query on a database, i do the following: while (rs.next()) { salvage everything from the current row. move the current row to a master table } question: what method should i use in order to select the current row and move it to the master table? is there a short way aside from the following? command = "insert into <master> " + "( " + "field1 " + "field2 " + "field3 " + ") " + "values " + "( " + rs.getString("field1") + ", " + rs.getString("field2") + ", " + rs.getString("field3") + ", " + ") " i know that there should be an api that has a method that would simply allow you to select the content of the whole row. tia jacq carballo