On 4/5/07, Dennis Birch <[EMAIL PROTECTED]> wrote: > In my tests the first query works fine, but when I try to query the > database a second time with a modified SELECT statement I get back a > recordset with 0 records. If I use the same modified query in a > database tester on the same database file, I get the results I expect.
It turns out the recordset IS being filled with the same number of records the second time around. The problem is occuring in a method where the data is parsed into another data structure. Before iterating over the recordset to load the data structure, I use the .MoveFirst method on the recordset. But after doing so, BOF is false and EOF is true. So it never gets processed in the "While not rs.eof" loop. Again, this is only happening after I've successfully done all this once to create the original report. What could cause that? _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
