|Posted by:||Karl Hungus (nnnnndddd…@hotmail.com)|
|Date:||Thu, 01 Apr 2004|
I would like to cycle through records (rows) one at a time in a table. My
primary key is not contiguous -- Im using a sequence to set it on insert.
whats the best way to structure the query to get a single record, and get
the primary key of the records before and after the current record? (eg.,
for prev/next buttons)