rs.RecordCount always -1

[GerardMcL]

Hi,

I am trying to export to a txt file. First fill a recordSet with required data - stick it in an array and print array to txt file.

But when I try to ReDim my array

ReDim array(7, strRecordSet.RecordCount)

RecordCount always = -1

Am I using this in the wrong way? Do I just need to do a COUNT statement and find length that way?

I know for sure there are records returned into this recordset.

 

[tazuk]

ADO Record Count is dependant on cursor location etc.
See thread222-889231 for illustration.

HTH

TazUk

Blue-screening PCs since 1998

 

[Sumitdev]

If you do a MoveLast it will populate the recordset and give you the number of records. You will need a check to make sure records exist first (not BOF or EOF).

 

[zemp]

It is also dependent on the cursor type. More info,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprorecordcount.asp

zemp