RecordCount on ADO recordset???

<i><b>Originally posted by : J. Feng (feng567@tfn.net)</b></i><br />Hi, All<br /><br />I created a ADO recordset through EDA midware on a DB2 database. The records in the recordset can be populated, but the RecordCount property of the recordset returns a -1 value.<br /><br />Is anyone here can help me on this problem?<br /><br />Thanks in advance!<br /><br />

<i><b>Originally posted by : notimportant (jhunt@alagreen.com)</b></i><br />The -1 is by design because the database may be in multi-use so the record count is "live".<br />you can loop thru the recordset and use a counter.<br />do until objRs.EOF<br />objRs.movenext<br />iNumRecords = iNumRecords+1<br />loop<br />Kind of silly but it works<br /><br />------------<br />J. Feng at 3/20/2001 8:58:29 AM<br /><br />Hi, All<br /><br />I created a ADO recordset through EDA midware on a DB2 database. The records in the recordset can be populated, but the RecordCount property of the recordset returns a -1 value.<br /><br />Is anyone here can help me on this problem?<br /><br />Thanks in advance!<br /><br />