i really not understand very well about rs.RecordCount or rs.move.. (the RecordCount seem not always work in different recordset situation, and rs.move.. i also wonder how it calculate the records ?? )
i just get the result from testing..(the newbie's way - keep trying..) and i think in theory, GB is right. just don't understand why if i add (-1), it will only show the last 24 replies.
the reasonable explanation for me, i think the rs.move count the records from 0 instead of from 1.... right ???
quote:Originally posted by DoraMoon i really not understand very well about rs.RecordCount or rs.move..(the RecordCount seem not always work in different recordset situation,
RecordCount property will return -1 for a forward-only cursor; the actual count for a static or keyset cursor; and either -1 or the actual count for a dynamic cursor, depending on the data source.
Edited by - GauravBhabu on 02 September 2002 03:00:24