Re: [Firebird-odbc-devel] OdbcFb 2.0 raises error when delete empty set

[Ivan R. <iv...@ni...>]

Is it possible to make this behavior tunable in datasource options (make
indicator "ODBC driver 1.x compatible" or something else, like transaction,
dialect or identifier options)?

Some programs support Firebird like outdated server and don't want support
new features and accept warnings like errors. I got this exception in CA
Data Modeler
(http://erwin.com/products/detail/ca_erwin_data_modeler_standard_edition/):

 

delete from DCT$Objects where Object_Name='AH_EXPORT_FACT'

 

[ODBC Firebird Driver]No rows updated or deleted

Execution Failed!

 

 

 

  _____  

From: Alexander Potapchenko [mailto:ale...@gm...] 
Sent: Thursday, January 27, 2011 1:22 PM
To: fir...@li...
Subject: Re: [Firebird-odbc-devel] OdbcFb 2.0 raises error when delete empty
set

 

On 27.01.2011 11:25, Ivan Ravin wrote: 

No rows updated or deleted

I think that SQLExecute returns SQL_SUCCESS_WITH_INFO (warning) instead of
SQL_ERROR. 
I think it is correctly.


Regards,
Alexander

-- 

Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru