RE: subfile page up & down using embedded SQL

["Fisher, Don" <Dfisher@xxxxxxxxxxxxxxxxx>]

I execute a COUNT function to determine the number of records in the file
before the "Position to" value and use FETCH RELATIVE from the beginning of
the file.

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx


<clip>
The "position to" will be the hard part since I'm going to guess that the
user will enter something that's meaningful to them (such as an order or
part number) and not the record number in your cursor. You may need to read
through all the rows in the cursor to do this. Of course, if the field just
means "skip ahead n records", then FETCH RELATIVE will work just fine for
that too.
<clip>