Re: cursor movement question?

From: Venkateswara R Polisetti <vrao_at_sctcorp.com>
Date: 1996/09/06
Message-ID: <1996Sep5.180910.8507_at_mcrcr6>#1/1

modrall_at_world.std.com (Mark W Modrall) wrote:

>i/'ve been poking around the proc precompiler book looking for a definition
>of the cursor in the hopes that i might find out how to move the pointer
>around without having to actually fetch all the intervening records, but the
>manual is fairly vague on the subject... there is a line saying that you
>can only skip forward, not backwards, but it doesn't give explanations... it
>also doesn't directly reference the idea of skipping directly to, say, the
>20th record of a result set...
 

>where should i be looking?
 

>thanks
>-mark

There is no way that you can skip backwards in a cursor. You can skip forward n rows only by executing the FETCH n times.

Venkateswara Rao
/-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-\

| Venkateswara R.Polisetti                 Email: vrao_at_sctcorp.com  |
| SCT Utility Systems, Inc.             Phone(O): (803) 935-8160    |
| 9 Science Court                            (R): (803) 736-1609    |
| Columbia, SC  29203-9344                                          |

\-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-/ Received on Fri Sep 06 1996 - 00:00:00 CEST