Re: Numer of rows in a cursor

Posted in 1997

Valery Fouques — Wed, 15 Jan 1997 21:51:40 +0100 — source: Informix-list mailing list archive (1991-1998)

Dr. Peer Griebel wrote: > > How can I determine the number of rows accessible by an open cursor? > For example I could go to the last row and determine it's number. But > how to determine this number? > > Do I have to do a 'select count ...' to determine the number of rows > or is there some other way? > > I'm using ESQLC with Informix 7.12. > > Thank you! Depends on if you want to know it BEFORE or AFTER having scanned the rows of your cursor : you coul set a variable...excuse me... -- Valery Fouques valou@hotmail.com SYSADM GOSPORT-FRANCE /\\oO/\\ _ __/| \\`O.o' "355/113 -- Not the famous irrational =(_ _)= number PI, but an incredible simulation!" U