query question

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)

TIA,
Karl Received on Thu Apr 01 2004 - 12:48:52 CST