-
friends,
REFERENCE:- SUB:- MY PREVIOUS POST TITLED "IS REQUERY FOOLPROOF"
ITS CONTENTS:-
i have used requery to refresh my recordset
for:
1. (DAO) Dynaset in 1 project.
2. (ADO) adcmdtable in another project.
will it automatically reset my Recordcount of the recordset, without having to close the recordset and open it once again.
REPLY FROM MR.CLUNIE:-
Use the Requery method to refresh the entire contents of a Recordset object from the data source by reissuing the original command and retrieving the data a second time. Calling this method is equivalent to calling the Close and Open methods in succession.
MY PRESENT TOPIC:-
first of all, thanks Clunie.
i too had read the help. but regarding the refresh of the recordcount, the help is not specific. certain properties will get refreshed only if you specifically close and reopen, help says. this will consume a lot of time. i want to know whether the .eof and .bof will get refreshed and recordcount will also get refreshed using requery.
please advice.
friendly,
jeyasree.
-
-
If requerying is equivalent to closing and opening a recordset, I would think that all other properties would be reset as normal. Is this not the case?
