RE: JDBC Style

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Chris,

The only case I can think of where an indication of records provides
value
is when some pre-processing is done when you find a record. It should
be
easy to condition that processing in the loop you process your result
set in.
However, it is usually better to provide some sort of interface that
wraps your
result set. That helps decouple the application from the database
implementation.
It also provides a place that you can code that empty set indicator
logic.

David Morris

>>> chris_price@nsb.co.uk 11/27/01 07:34AM >>>
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