Re: Fetch out of sequence - server 7.3.2

Delphis Group Limited wrote:
>
> Hi
> On running a specific report on a client site a -1002 fetch out of
> sequence is generated.
>
> Does anyone have any experience of this?

This occurs in two different scenarios:

1. when an application attempts to perform a FETCH against a cursor that has not been opened.
2. When an application attempts to perform a FETCH against a cursor that has returned 1403 from the last fetch. Keep in mind that 1403 (No data found) is not an error because it is a positive value instead of a negative one. It is not an error to retrieve the last row of a cursor - however, it is an error to perform additional fetches once 1403 has been returned.

And yes, I do have experience with this. Received on Thu May 18 2000 - 00:00:00 CDT