OdbcFb 2.0 raises error when delete empty set

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

OdbcFb 2.0 raises error when delete empty set

Ivan Ravin-3

OdbcFb 2.0 raises error when execute DELETE statement on empty table or delete on empty set:

 

delete from DCT$Objects where Object_Name='AH_EXPORT_FACT'
 
[ODBC Firebird Driver]No rows updated or deleted
Execution Failed!

 

 

There is no such error with 1.2 driver, but every 2.0 driver raise it:

OdbcJdbc v2-0-Beta Ver 02.00.00.0144
OdbcJdbc Ver RC1_2-0-0148
OdbcJdbc Ver RC1_2-0-0150
 

And error message looks like UPDATE statement on empty set will raise it too


------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|

Re: OdbcFb 2.0 raises error when delete empty set

Alexander Potapchenko-2
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

------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|

Re: OdbcFb 2.0 raises error when delete empty set

Ivan Ravin-3

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:[hidden email]]
Sent: Thursday, January 27, 2011 1:22 PM
To: [hidden email]
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


------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Reply | Threaded
Open this post in threaded view
|

Re: OdbcFb 2.0 raises error when delete empty set

Alexander Potapchenko-2
On 09.03.2011 10:31, Ivan Ravin wrote:

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!

 

 

 


Hi Ivan,
For information: this code is added here - http://tracker.firebirdsql.org/browse/ODBC-13.
If CA Data Modeler can't work with warnings, then I think you need special build
...

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

------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Firebird-odbc-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel