On 4/5/07 7:59 PM, "Dennis Birch" <[EMAIL PROTECTED]> wrote:
> 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. I believe MoveFirst is currently broken in Realsqldatabase. (Due to an underlying bug in SqlLite.) See: <http://www.realsoftware.com/feedback/viewreport.php?reportid=tiqxirgx> -- Russ Tyndall Wake Forest, NC _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
