Icon View Incident Report

Serious Serious
Reported By: Roy Lambert
Reported On: 1/15/2008
For: Version 1.07 Build 2
# 2529 SELECT Statements with JOINs that Reference Other Databases Can Cause AV

Running the following SQL I get:

ElevateDB Error #700 An error was found in the statement at line 348 and column 47 (Access violation at address 004FD862 in module 'edbmgr.exe'. Read of address 0000005C)

I'm not even prompted for the paramter value.

SELECT
_fkProjects,
_LastAccess,
(IF(_LastAccess IS NOT NULL THEN
CAST((CURRENT_TIMESTAMP - _LastAccess)DAY AS INTEGER) ELSE
99999)) AS _LongAgo,
P._Name,
P._Type,
P._fkOrderBook,
IF(P._Status = 'L' THEN 'Live'
ELSE IF(P._Status = 'D' THEN 'Dead'
ELSE IF(P._Status = 'H' THEN 'Hold' ELSE '')))AS _Status,
_fkUsers
FROM
mruProjects
JOIN "NLH-Live"."Projects" P ON _fkProjects = P._ID
WHERE
_fkProjects <> :Schedule
ORDER BY
_LongAgo



Resolution Resolution
Fixed Problem on 1/16/2008 in version 1.07 build 3


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

Image