Reported By: Roy Lambert Reported On: 3/23/2007 For: Version 1.01 Build 1
# 2282SET Clause with Correlated Aggregate Sub-Query in UPDATE Statements Results in Column Set to NULL The following SQL nulls the _Balance column.
UPDATE accounts SET _Balance=
(select sum(_income) - sum(_expenditure) AS BAL
from transactions where transactions._fkaccounts=accounts._ID)
WHERE accounts._adjustor = 1
ResolutionFixed Problem on 3/26/2007 in version 1.02 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial