RE: JDBC Style

["Clapham, Paul" <pclapham@xxxxxxxxxxxxx>]

boolean isEmpty = true;
while (rs.next()) {
  isEmpty = false;
  // process the record
}


-----Original Message-----
From: Price, Chris [mailto:chris_price@nsb.co.uk]
Sent: November 27, 2001 06:35
To: 'java400-l@midrange.com'
Subject: RE: JDBC Style


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Thanks for the answer Dan.

The "problem" I have with using next() to determine if a record set is empty
, is that it moves the file pointer (oops - betraying my RPG origins now) I
mean cursor, so the result set is changed. I know I can move it back again,
but this seems a bit sloppy to me, hence my post.

The problem may well of course be mine, I'm that I'm still thinking like an
RPG programmer and want to know why I can't have my file indicators
back....(VBG)

Chris