How do I count the number of records returned from a query? I have a screen that shows three records at a time. I am wanting to say "Records 1 - 3 of X". How do I get the X? Thank you for any help.
rs.open "Select * From MyTable", ObjConn,3,3<BR>MyRs.MoveLast<BR>RecordCount = MyRs.RecordCount
many methods are there<BR>1.rs.recordcount(not supported by all databases)<BR>2.myarr=rs.getrows()<BR>recordcount= ubound(myarr,2)<BR>3.with in loop increment a counter