Reported By: Richard Harding Reported On: 11/4/2007 For: Version 1.05 Build 2
# 2469NOT EXISTS Operator Not Working Properly in UPDATE or DELETE WHERE Clause The NOT qualifier is being ignored in the following statement.
UPDATE Stock
SET flag = 'A'
WHERE NOT EXISTS
(SELECT * FROM StockOLD
WHERE Stock.stocknumber= StockOld.stocknumber)
ResolutionFixed Problem on 11/5/2007 in version 1.06 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB DAC Client-Server ElevateDB DAC Client-Server with Source ElevateDB DAC Standard ElevateDB DAC Standard with Source ElevateDB DAC Trial ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial