I need to write an SQL statement to get the Largest number out of an Access database table. I know it sounds simple but when I try "SELECT MAX (Question.qID) FROM Question"; this does not work, it says "Column Count not Found". If I run the query in Access then it works but I need to be able to get this number in
JAVA so that I can then add one to it for a new id number. When I try just listing the id numbers in the table it works but when I add the MAX to the query I get an error. Thank you for your help!!
I have been trying something like:
private int getNewQID(){
int qID = 0;
String sql3 = "SELECT Max(Question.qID) FROM Question";
try{
rs = dataAccess.runSelectQuery(sql3);
while (rs.next()){
qID = (rs.getInt("qID"));
qID = qID +1;
System.out.println(qID);
}
}catch(Exception sqle) {
System.err.println("SQL NOT Executed: " + sqle);
}
return qID;
}