Re: embedded SQL fetch relative -29 ...

On 13-Nov-2015 02:56 -0600, Booth Martin wrote:

Using SQL, I can page ahead in a page-at-a-time subfile easily but
when it comes time to page down, I believe the best way is for me to
use fetch retrieve - (2 pages +1). The few examples I have been able
to find seem correct and to the point, but I can not make them work.
I am missing something. <<SNIP>>

The Subject says RELATIVE -29 but the text suggests PageDown [which in the common vernacular, is /forward/ through the data].? Also "not ... work" is quite nebulous.

Regardless, of possible note: "The following keywords specify a new position for the cursor: NEXT, PRIOR, FIRST, LAST, BEFORE, AFTER, CURRENT, and RELATIVE. Of those keywords, only NEXT may be used for cursors that have not been declared SCROLL." That is, if the cursor is not declared scrollable, then there is no ability to FETCH RELATIVE; I presume if that were the issue, then the FETCH RELATIVE would have failed with an error condition, such that "not ... work" could have been described by an SqlCode.?