I am trying to execute a long Update sql statement but I am getting an
Dynamic SQL Error (error code -104).
After that error I loose the connection with the database for some strange
reason.
Steps to reproduce:
1. Download the solution from this link:
http://www.grbytes.com/downloads/Firebird_sql_error.rar
2. Run the project and click on the "Create Connection" button to create a
connection with the database
3. Click the "Execute SQL" button to execute the long update statement. You
will see the error. Please notice that the connection with the database is
also lost for some reason. If you click again the "Execute SQL" button you
will see an other error.
It looks like a bug, but I am not sure.
My question is if there is a limitation for the length of the sql statement
and why the connection is lost after failing to execute it?
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
