Getting next record in sql server db
Posted on 2015-02-21
Lets say I have x records in my recordset. I write those to an array and "use" those and then more are added. II don't know how many more were added. I want to go back to where I left off and grab just the new records. I did create a marker like this:
iLastRcd = rs.RecordCount
How do I re-open the recordset from there without missing any new records and without grabbing any existing records.
Here is the sql query that I am using:
sql = "SELECT Bib, Chip, Time, Reader, Antenna FROM RawRFID WHERE EventID = " & lEventID