Hello,

> While commiting the stored procedure, i am getting this error.

What is the DDL of the table BATCHMASTER?

>
> Cannot commit transaction:
> This column cannot be updated because it is derived from an SQL
> function or expression.
> attempted update of read-only column.
>
> What is the problem in my stored procedure?
>
> UPDATE BATCHMASTER SET BATCHCST=:BATCHCST,
> BATCHMRP=:BATCHMRP,
> BATCHSELLINGRATE=:BATCHSELLINGRATE,
> BATCHTPS=:BATCHTPS,
> EXPIRYDATE=:EXPIRYDATE,
> PURCHASECOST=:PURCHASECOST,
> STOPBILLING=:STOPBILLING,
> BATCHSTOCK=:ORGBATCHSTOCK+:TRANSFERQUANTITY,
> EXPIRY=:EXPIRY,BATCHRATE=:BATCHRATE
> WHERE BATCHNUMBER=:BATCHNUMBER AND
> PRODUCTSERIALNUMBER=:PRODUCTSERIALNUMBER AND
> ITEMCODE=:ITEMCODE;
>
> This is the sql in the stored procedure.

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."