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