But i wanna know why is that whenever i use DeleteRow() method of ResultSet class i gives me "invalid cursor state" even though it is deleting the row from the Db.
i am guessing in the last loop in the while Loop, when it deletes a row Say the last row of the Table and as we know whenver it deletes a row it increments by one position. now when cursor again goes back to
---> while(rsAcd.next()) position, it may tries to locate the next available row in which case it is already ahead of last row.... i believe thats when it fires the exception "invalid cursor state".
am i guessing rt or is there something else??
Thanks for any help!!