The following code changes the product prices on the selected document (document 40 in this example).
Price is converted equal to the purchase price:
|
1 2 3 4 5 |
update "grammes" set "grammes"."Timh"= (select "apouhkh"."Timh_s" from "apouhkh" where "apouhkh"."Aa"="grammes"."Eidos") where "grammes"."Aapar" in (select "pvlhseis"."Aa" from "pvlhseis" where "pvlhseis"."Parastatiko"=40) |
Price is converted equal to the sale price:
|
1 2 3 4 5 |
update "grammes" set "grammes"."Timh"= (select "apouhkh"."Lianikh" from "apouhkh" where "apouhkh"."Aa"="grammes"."Eidos") where "grammes"."Aapar" in (select "pvlhseis"."Aa" from "pvlhseis" where "pvlhseis"."Parastatiko"=40) |
