Icon View Incident Report

Serious Serious
Reported By: Roy Lambert
Reported On: 10/1/2009
For: Version 2.03 Build 3
# 3075 INSERT INTO SELECT Statements Incorrectly Including Deleted Rows

I wanted to get a table (EMails) across from the live to the development database again so I could check something out. I set up a session in EDBManager to access both databases, deleted everything from DEV.EMails and ran


Fine but there were 71 records in mailbox -8 when there should have been 3. Check LIVE.EMails and it only shows 3!

The extra 68 were all records that had been deleted.

To get rid of the ones that shouldn't have been there I had to optimise LIVE.EMails

Resolution Resolution
Fixed Problem on 10/1/2009 in version 2.03 build 4

Products Affected Products Affected
ElevateDB 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 LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial