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

[Carlos G.A. <car...@ho...>]

Hello:


>>IscStatement::getResultSet()

>>...
>>    if ( !selectActive )
>>        if (outputSqlda.sqlda->sqld < 1)
>>            throw SQLEXCEPTION (RUNTIME_ERROR,

this works if you make

   if ( selectActive )
       if (outputSqlda.sqlda->sqld < 1)
           throw SQLEXCEPTION (RUNTIME_ERROR,


Best regards
Carlos Guzmán Álvarez



>From: Paul Reeves <pr...@ib...>
>Reply-To: fir...@li...
>To: fir...@li...
>Subject: Re: [Firebird-odbc-devel] PRoblem with the driver
>Date: Mon, 12 Aug 2002 14:43:52 +0200
>
>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
>
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:ThinkGeek
>Welcome to geek heaven.
>http://thinkgeek.com/sf
>_______________________________________________
>Firebird-odbc-devel mailing list
>Fir...@li...
>https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


Un saludo

Carlos Guzmán Álvarez
Vigo-España

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

_________________________________________________________________
Charle con sus amigos online usando MSN Messenger: http://messenger.msn.com