Database question ...
-
Hi all. What is Requery() ??? Is it for refresh recordset ? So, when i add/new/delete/edit each record, i must use it ? My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie
-
Hi all. What is Requery() ??? Is it for refresh recordset ? So, when i add/new/delete/edit each record, i must use it ? My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie
G'day Hadi, Requerying a recordset is functionally similar to closing and re-opening the recordset without some of the overhead. It's useful for those situations where you open a recordset which is sorted on a particular field. Now, say you add some records to the set. These new records 'appear' at the end of the recordset and not necessarily in their properly sorted position in the recordset. Just call Requery() and all of the records will be re-sorted. I hope this makes sense. Steve
-
G'day Hadi, Requerying a recordset is functionally similar to closing and re-opening the recordset without some of the overhead. It's useful for those situations where you open a recordset which is sorted on a particular field. Now, say you add some records to the set. These new records 'appear' at the end of the recordset and not necessarily in their properly sorted position in the recordset. Just call Requery() and all of the records will be re-sorted. I hope this makes sense. Steve
Hi steve. Thank you for useful answer ... :) My month article: Game programming by DirectX by Lan Mader. Please visit in: www.geocities.com/hadi_rezaie/index.html Hadi Rezaie