Printable View
for 'further clarification needed' the reply was:
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?
reply:
thanks Clunie...
but msdn help says in the same page that certain properties will not get reset when the recordset is open! is it worth taking the risk?
please advise!
jeyasree.
Requerying will just refresh the records (close and reopen), it will not alter any properties unless you set the recordset itself to nothing and create a new instance of the recordset, in which case, will apply the default properties. So, if you opened the recordset with forward only cursor, requerying will not alter the cursor, it will remain a forward only cursor and so is the other properties. You can verify this by checking the properties before and after requery.
------------------
Share your knowledge, it is the best way to achieve immortality
Well, I guess I should have done my homework!
Anyways, creating and destroying a recordset is not as time consuming as, for example, a connection, so just set the rs = nothing and instantiate it again. Either way you'll have to reissue the query against the database, so the only difference is re-creating the recordset object.