I have an application with a loop that loads data into a recordset via SQL, then performs some calculations and reloads a new set of data into the same recordset(in place of the old data).
How do I clear the BOF and EOF settings of the recordset when I load new data into the recordset?
It is currently giving my incorrect EOF/BOF values when I load the second set of data into the recordset.
Thanks,
Dan