Re: [Firebird-odbc-devel] PRoblem with the driver

[Paul R. <pr...@ib...>]

Carlos G.A. wrote:


> Im making test to the driver with the microsoft odbc test program, this 
> program have an option for creating a table, a index in the table, make 
> a select and insert data in the table created, using the information 
> returned by SQLGetTypeInfo, well, the 3 first steps works well but the 
> insert of data fails, i made a fix for this:
> 

What is wrong with testing for selectActive? IscStatement::execute() 
will set it true if the statement returns a result set.

We should probably change the case statement consider 
isc_info_sql_stmt_exec_procedure.

I propose this as an alternative:

IscStatement::getResultSet()

...
     if ( !selectActive )
         if (outputSqlda.sqlda->sqld < 1)
             throw SQLEXCEPTION (RUNTIME_ERROR,
		"current statement doesn't return results");

...


> Move this in OdbcStatement::sqlPrepare:
> 
>     if( updatePreparedResultSet )
>         setResultSet ( statement->getResultSet() );
> 
> into try...catch block: 

Done.



Paul
-- 

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase