It gives runtime error with "result.getInt("FY")".But if we substitute
the real Values it works fine...
SelStmt= "Select t1.* "
+ "from program t1, quarter t2 "
+ "where (t1.fy=t2.fy and t1.quarter= t2.quarter) and activity_grp_code='PA'";
stmt = con.prepareStatement(SelStmt);
bFlag = stmt.execute();
result = stmt.getResultSet();
max = stmt.getMaxRows();
PreparedStatement Seltmpstmt = null;
Seltmpsql="Select sdate,edate from quarter "
+"Where" + result.getInt("FY");
A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set.