i editted the code to bcome...
String sql = "SELECT LAST(StaffId) FROM Staff WHERE StaffId LIKE 'S*';";
try{
rsStaffId = stmtQuery.executeQuery(sql);
...
Type: Posts; User: derick_ho
i editted the code to bcome...
String sql = "SELECT LAST(StaffId) FROM Staff WHERE StaffId LIKE 'S*';";
try{
rsStaffId = stmtQuery.executeQuery(sql);
...
i wanted to get the last staff id from database and generate the lastest staff id..
but i cannot get the expected result..
String sql = "SELECT StaffId FROM Staff WHERE StaffId LIKE 'S*';";
...