Thread

1. Cursor Movement - Past the End

   David Hartwig <daveh@insightdist.com> — 1998-12-07T19:19:18Z

   We are in the process of implementing several additional Extended Fetch
   capabilities into the ODBC driver.  In order to complete the full set of
   functions, we need to be able to FETCH to the end of the cursor, detect
   the end, and then be able to move to prior positions in the the cursor.
   The problem is that once the end of the cursor is reached the cursor is
   no longer usable.
   
   I think the cursor should still be valid after moving past the end.  I
   have tinkered around to see if the cursor can be preserved after
   moving/fetching past the end without much luck.    I am throwing this
   out to the list in the hopes that someone will respond "Gee, Dave, all
   you have to do is (*^%^$$%$#!)".
   
   I would greatly appreciate any assistance in resolving this problem.
   Many ODBC components and applications make heavy use of these extended
   features.
   
   TIA.
   
   
   

2. Re: [HACKERS] Cursor Movement - Past the End

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-12-13T04:34:19Z

   > We are in the process of implementing several additional Extended Fetch
   > capabilities into the ODBC driver.  In order to complete the full set of
   > functions, we need to be able to FETCH to the end of the cursor, detect
   > the end, and then be able to move to prior positions in the the cursor.
   > The problem is that once the end of the cursor is reached the cursor is
   > no longer usable.
   > 
   > I think the cursor should still be valid after moving past the end.  I
   > have tinkered around to see if the cursor can be preserved after
   > moving/fetching past the end without much luck.    I am throwing this
   > out to the list in the hopes that someone will respond "Gee, Dave, all
   > you have to do is (*^%^$$%$#!)".
   > 
   > I would greatly appreciate any assistance in resolving this problem.
   > Many ODBC components and applications make heavy use of these extended
   > features.
   
   Added to TODO:
   
   	* make CURSOR valid even after you hit end of cursor
   
   -- 
     Bruce Momjian                        |  http://www.op.net/~candle
     maillist@candle.pha.pa.us            |  (610) 853-3000
     +  If your life is a hard drive,     |  830 Blythe Avenue
     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026