Same here .MoveFirst does not move to the first entry... If you fill a Bug Report. I'll sign it.
2007/4/6, Dennis Birch <[EMAIL PROTECTED]>: > > 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> > _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
