Re: query question

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 1 Apr 2004 14:04:09 -0500
Message-ID: <SrudnUlG7KBI-vHd4p2dnA@comcast.com>

"Karl Hungus" <nnnnndddddd_at_hotmail.com> wrote in message news:ouZac.12$mX.175700_at_twister.nyc.rr.com...
|
| 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
|
|

sql is set oriented, not record oriented, so this is not a typical way to use the language

typically this functionality is best handled by buffering the PKs, or the actual records, via the UI tool

could you describe your process and toolset (and versions would be good, too)?

;-{ mcs Received on Thu Apr 01 2004 - 13:04:09 CST