"meere" <yjung98_at_hanmail.net> wrote in message
news:1141631448.842963.158380_at_z34g2000cwc.googlegroups.com...
> I have a problem with GetRecordCount() in VC ..
>
> When I execute SP returning multiple rowset using ref_cursor, this
> process is succeed in excuting. But the result of GetRecordCount is -1.
>
> If the result of SP is NULL and then I excute MoveFirst() or
> MoveLast(), it occurs Exception.
>
> So, I try to count of the result to check whether the result is NULL or
> not. But I could't this because of limitation of GerRecordCount.
>
> Anyone knows how to count the recordset, help me....
>
> In advance, thanks for your help.
>
> Regards,
> Meere.
>
It isn't going to know what the number of records are until you retrieve all
the records. Executing the stored procedure just returns a cursor; you have
to fetch all the records to know how many you have.
Jim
Received on Mon Mar 06 2006 - 09:20:20 CST
