Quote:
quote:Originally posted by pgtips
Sounds like you have the wrong cursor type. When you use syntax like this
Code:
rs.Open qrystring, oconn
to open a recordset you get the default forward-only cursor (so you can't MovePrevious)
change it to another cursor type, for example
Code:
rs.Open qrystring, oconn, adOpenStatic
|
Lets Suppose I have 2 records (the query in the above code return these)
one for the date 31-01-99
and ohter for 29-02-99
now say the first record it shows is 31-01-99
then press move next button it showed me the next record , If I again press the movenext buton it gives me error
"Either EOF or BOF is true, or the current record has been deleted, Requested operation requires the surrent recoed"
Same is the case with moveback buuton
Now How Can I remove this error (Plz refer to the code(rs_movenext , rs_moveback) I've given above and consider the line "rs.Open qrystring, oconn " as
"rs.Open qrystring, oconn, adOpenStatic")