Icon View Incident Report

Serious Serious
Reported By: Roy Lambert
Reported On: 3/23/2007
For: Version 1.01 Build 1
# 2282 SET 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

Resolution Resolution
Fixed Problem on 3/26/2007 in version 1.02 build 1

Products Affected Products Affected
ElevateDB 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