I'm query and store procedure.

After execute the query and retrieve data by using vb6.

I want to display the total rows returned from query.

I get the -1 value from recordset.recordcount.

Can anyone help me? thanks a million......