Thursday, March 30, 2006, 9:34:50 AM, Jan wrote: > There's nothiong worng with your SELECT query ; the
<g> > problem is in the ODBC database driver not always > returning the correct record count. I've seen this > with Access and Progress databases as well. See BZ #3291 for details about revNumberOfRecords(). Issuing a "SELECT COUNT(1)" query on the recordset data seems to work properly. > Unfortunately, some databases only support read-only > forward-only cursors -- so you should traverse the > record set and fetch all the data you want in one go. Actually, the database cursors for *all* ODBC databases are implemented as forward-only, which is a really stupid design decision. The official excuse for this is that "the docs document that certain ops don't work with certain databases"... Please add votes to BZ #1528 to get this fixed. It's been idle for some two years now... -- -Mark Wieder [EMAIL PROTECTED] _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
