Re: %ROWCOUNT in Cursor

From: Will Kooiman <wkooiman_at_csac.com>
Date: 1997/05/29
Message-ID: <338D15AD.743@csac.com>#1/1

I'm not sure exactly what you want.

You CANNOT get the number of rows a cursor is -going- to return (unless of course you do the same query with "select count(*)...").

You can access sqlca.sqlerrd[2] to see how many rows were processed with the last fetch, but for a cursor (w/out array processing), it will always be 0 or 1.

Will.

-- 
======================================================================
Will Kooiman                        Computer Systems Authority
Systems Consultant                  6380 LBJ Freeway, Suite 181
(972) 960-0180 x236                 Dallas, TX 75240
mailto:wkooiman@csac.com            http://www.csac.com

Received on Thu May 29 1997 - 00:00:00 CDT