解决方案: |
执行以下语句:
UPDATE RdRecords
SET iOriMoney = iQuantity * iOriCost,
iOriTaxPrice = iQuantity * iOriCost * iTaxRate / 100,
ioriSum = iQuantity * iOriCost + iQuantity * iOriCost * iTaxRate / 100,
iTaxPrice = iQuantity * iOriCost * iTaxRate / 100,
iSum = iQuantity * iOriCost + iQuantity * iOriCost * iTaxRate / 100
WHERE (ID IN
(SELECT id
FROM RdRecord
WHERE (bRdFlag = 1) AND (cVouchType = '01'))) AND
(iPrice <> iQuantity * iUnitCost) AND (iPrice <> iOriMoney) OR
(ID IN
(SELECT id
FROM RdRecord
WHERE (bRdFlag = 1) AND (cVouchType = '01'))) AND (iPrice <> iOriMoney) AND
(iOriMoney <> iQuantity * iOriCost) |