No. of rows selected

Posted in 1998

Adam Sorati — Wed, 25 Feb 1998 19:13:23 +1100 — source: Informix-list mailing list archive (1991-1998)

Informix On-line 5.x ISQL 4.x Hello, I have a cursor in which I create from a query by example, I then use a foreach statement to display each row. Is there anyway of displaying the total number of records selected to the user. I looked at the value of SQLCA.SQLERRD[3] directly after the foreach statement but it always has a value of zero. I am currently using a second cursor to select the count(*) which is making the selection very slow because I'm doing 2 selection. Thank you for reading my question I hope you can help me. Adam Sorati