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
-------------------------------------------------------------------------
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
