From: Mercea P. <pau...@al...> - 2008-04-01 13:30:07
|
Hi 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 If I run SP from IBExpert works as expected with both FB SS versions. SP content looks like : For select a,b,c from table1 t1 Into :v_a,:v_b, :v_c do begin If (exists(select 1 from table2 t2 where t2.id= :v_a and t2.v=:v_b)) then Begin Delete from table2 t2 where t2.id=:v_a and t2.v=:v_b; End Insert into table2 (t2a,t2b,t2c) Values (:v_a, ,:v_b, :v_c); If I delete IF condition and DELETE statement it works without errors. Regards, Paul |