Icon View Incident Report

Serious Serious
Reported By: Roy Lambert
Reported On: 1/19/2010
For: Version 2.03 Build 7
# 3135 Using ALTER TABLE to Move Columns that are Referenced in Triggers Can Cause AV

The following SQL causes the error:

Access violation at address 0051E8B1 in module 'edbmgr.exe'. Read of address 00000074

ALTER TABLE "Companies"
ADD COLUMN "_PNotes" VARCHAR(35) COLLATE "ANSI_CI",
ALTER COLUMN "_PNotes" MOVE TO 17,
ALTER COLUMN "_PNotes" MOVE TO 16



Comments Comments
The problem was caused by the _PNotes column being referenced in several triggers via the OLDROW and NEWROW trigger row variables.


Resolution Resolution
Fixed Problem on 1/19/2010 in version 2.03 build 8


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

Image