Re: Fetch Last returns incorrect record

Posted in 2000

Obnoxio The Clown — Wed, 12 Apr 2000 14:41:40 BST — source: Informix-list mailing list archive (1991-1998)

From: "George Georgiou" <ggeorgio@csc.com> > >I have defined a scroll cursor with hold and the records are ordered. The >program using "FETCH ABSOLUTE i" where "i" is the record position retrieves >the 1st to the nth record and then the 1st again. If after that I try to >fetch the last record using "FETCH LAST" it returns the 1st record in the >active set. Sure the cursor isn't being reopened somewhere? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

↪ replying to Obnoxio The Clown

George Georgiou — Wed, 12 Apr 2000 16:50:17 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi I wrote a small application to test this scenario and I was able to recreate this every time. The cursor is opened only once and if the FETCH LAST is executed twice the second time it returns the correct record. Thanks for your reply. George Obnoxio The Clown <obnoxio@hotmail.com> wrote in message news:8d20kf$r72$1@news.xmission.com... > > From: "George Georgiou" <ggeorgio@csc.com> > > > >I have defined a scroll cursor with hold and the records are ordered. The > >program using "FETCH ABSOLUTE i" where "i" is the record position retrieves > >the 1st to the nth record and then the 1st again. If after that I try to > >fetch the last record using "FETCH LAST" it returns the 1st record in the > >active set. > > Sure the cursor isn't being reopened somewhere? > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com >