Re: deleting a record - still a problem

[John English]

On 23/10/2013 06:44, Bob M wrote:

The error is that my SELECT can not have "For UPDATE" ????

s.setCursorName("MYCURSOR");
rs = s.executeQuery("SELECT * FROM tablename ORDER BY Date ASC, Time ASC
FETCH FIRST ROW ONLY FOR UPDATE");

So it *can* have FOR UPDATE...

rs.next();

psDelete = conn.prepareStatement("DELETE FROM tablename WHERE CURRENT OF
MYCURSOR");
statements.add(psDelete);

Why not just use rs.deleteRow() instead of using a cursor?

--
John English