DboOdbc::execute($sql, $options = array()) gives random errors without a real cause

[ghost]

Created by dalpo, 19th Mar 2010. (originally Lighthouse ticket #18):

---

I encountered this problem trying to develop a MS Access datasource via odbc.
This is the problem:

DboOdbc::execute is inherited by DboSource::execute method...

    function execute($sql, $options = array()) {
        $defaults = array('stats' => true, 'log' => $this->fullDebug);
        $options = array_merge($defaults, $options);

        $t = getMicrotime();
        $this->_result = $this->_execute($sql);
        if ($options['stats']) {
            $this->took = round((getMicrotime() - $t) * 1000, 0);
            $this->affected = $this->lastAffected();
            $this->error = $this->lastError(); // <<<<  TAKE A LOOK HERE
            $this->numRows = $this->lastNumRows();
        }

        if ($options['log']) {
            $this->logQuery($sql);
        }

        if ($this->error) {
            $this->showQuery($sql);
            return false;
        }
        return $this->_result;
    }

Whose method invokes the $this->lastError(); even if there isn't errors.
So this is a problem because the odbc error reporting functions odbc_error and odbc_errormsg should be invoked only when odbc_exec() return false
Otherwise, in my case it gives random errors..

From php.net:

This function returns meaningful value only if last odbc query failed (i.e. odbc_exec() returned FALSE).

References:

http://php.net/manual/en/function.odbc-error.php

http://www.php.net/manual/en/function.odbc-errormsg.php

I hope to be helpful and sorry for my bad English ^_^'

bye