Re: [Firebird-net-provider] Error message "attempted update of read-only column"

[Helen B. <he...@tp...>]

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