Hi,
RecordCount property returns actual number for a static or keyset cursors and -1 or actual number for a dynamic cursor, depending on the data source. Client-side cursor may be only static.

>I am getting a recordset object from SQL store Proc. here is my code...
>
>rs.OPEN(cmd)
>
>cmd is command object and all property is set in that. Now what exactly i have to set , like cursortype or any thing so i can get RECORDCOUNT > 0
>rs has records in it but only RECORDCOUNT = -1.
>
>( I do get result set from Store Proc.)