>Sir I have these code
>
>

>UPDATE cr_sale SET weight=SUM(crsalp.qty*crsalp.weight) from crsalp WHERE cr_sale.vou_no=crsalp.vou_no
>

>
>it says:
>
>File 'sum.prg' does not exist.
>
>Please help

Maybe you need a SELECT in front of the SUM()?

UPDATE cr_sale SET weight= SELECT SUM(crsalp.qty*crsalp.weight) from crsalp WHERE cr_sale.vou_no=crsalp.vou_no