I have a java program cycling though records in a table as follows;
resultSet = sel.executeQuery("SELECT rowid FROM " + final_table + " WHERE cba_granule=" + x);
//Assign a CBA_RECORD number to the entry.
s = sel.executeUpdate("UPDATE "+final_table+" SET cba_record = "+temp+" WHERE rowid='"+resultSet.getString(1)+"'");
Any ideas why this doesn't work; could it be i need to lock the rows/row that i'am using?