Subject Re: [Firebird-Java] Re: JDBC
Author William L. Thomson Jr.
On Wed, 2003-07-30 at 08:46, Robert Rylly wrote:
> Does anyone have the code to navigate through record sets is JDBC does not
> allow cursor positioning?
> How do you move previous, next, first, last, etc...l?

By placing the result set data into an array or vector. However there
could be synchronization issues, if the data is updates or modified
after the data has been retrieved. Not to mention inefficiency if you
are only working with a few records at a time.

Or by using different SQL statements using things like FIRST n SKIP x in
conjunction with ORDER BY and/or WHERE.

This is where using things like MAX(),MIN(), and etc can also help out.

William L. Thomson Jr.
Support Group
Obsidian-Studios, Inc.