Cursor Cursor Cursor 
Author Message
 Cursor Cursor Cursor
Hi all,

I got the below error from SQL 2000 after migrating from
SQL6.5.  Do not have that error when running the Customer
SP in SQL6.5.

Server:Msg 16911, Level 16, State 1, Procedure Customer,
Line 312.  Fetch:  The fetch type first cannot be used
with forward only cursors.

Does it means that Fetch Type First is no longer support
with Forward only cursors in SQL 2000 or ...?  Please
advise.  Thanks.

Cheers
Derek



Mon, 03 May 2004 09:58:45 GMT
 Cursor Cursor Cursor

Derek,

Was it ever?   The definition of a Fast-Forward cursor is strictly one way.
Since it always starts at the first row why would you need a Fetch First?  I
think Next is the only appropriate Fetch type.

--
Andrew J. Kelly,  SQL Server MVP
TargitInteractive


Quote:
> Hi all,

> I got the below error from SQL 2000 after migrating from
> SQL6.5.  Do not have that error when running the Customer
> SP in SQL6.5.

> Server:Msg 16911, Level 16, State 1, Procedure Customer,
> Line 312.  Fetch:  The fetch type first cannot be used
> with forward only cursors.

> Does it means that Fetch Type First is no longer support
> with Forward only cursors in SQL 2000 or ...?  Please
> advise.  Thanks.

> Cheers
> Derek



Mon, 03 May 2004 21:24:57 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Could not complete cursor operation, because the table schema changed after cursor was declared

2. cursor without cursors

3. Could not complete cursor operation, because the table schema changed after cursor was declared

4. Need Help Please , Invalid Cursor Position Error and Cursor Not Open Error

5. Should I use ODBC cursors or Server cursors?

6. declare curW cursor for EXEC spMySproc - Trying to assign sp resultset to cursor variable

7. client side cursor vs. server side cursor

8. Why declare cursor and open cursor both cost same amount of time

9. Detect if Cursor Opened and Detect if Cursor Allocated

10. Cursor in Trigger - with cursor not open when running second time in the same SQL session

11. Passing a CURSOR value to another cursor


 
Powered by phpBB® Forum Software