At 11:29 PM 1/04/2008, Mercea Paul wrote:
>Using FB 1.5.5 SS , FB.Net provider 2.5, VS C#2005.
>
>Database created with FB 1.5.3, ODS 10.1, Dialect 1.
>
>I have a SP which is running fine like execute procedure
>balance(@p1,@p2,@p3);
>
>The same database, but under FB 2.1 RC2 (17755), running same SP I get this
>error:
>
>base {System.Data.Common.DbException} = {"attempted update of read-only
>column"}
>
>ErrorCode = 335544359
In Firebird 2 and higher you will get this exception if you have an AFTER
trigger that attempts to update a column in the table that owns the trigger.
As to the rest, you have a confusion of cursors there, as well as a confusion
of table/set qualifiers. Study the Firebird 2/2.1 release notes to understand
why some of your statements might now be "illegal". However, the exception you
are seeing is not one of those that you would see as a result of the errors in
your stored procedure. I think you will discover its cause in a trigger.
>If I run SP from IBExpert works as expected with both FB SS versions.
Are you actually executing it, or just running it in the IBExpert debugger? If
the latter, it is likely that you need to upgrade your IBExpert to a version
that supports Firebird 2 and higher. Firebird 1.5 and below were more tolerant
to poorly-qualified SQL statements which means that older debugging tools are
no longer valid.
Better to test it in isql.
Helen
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
