ODBC connection to MS SQL 2000 help needed

Mark Wieder mwieder at ahsoftware.net
Thu Mar 30 17:32:46 EST 2006

Thursday, March 30, 2006, 9:34:50 AM, Jan wrote:

> There's nothiong worng with your SELECT query ; the


> 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
 mwieder at ahsoftware.net

More information about the Use-livecode mailing list