Icon View Incident Report

Serious Serious
Reported By: Uli Becker
Reported On: 3/20/2008
For: Version 1.08 Build 1
# 2568 Incorrect Variable Name References in SQL/PSM Routine Cause Incorrect Error Message

I pasted a text into the Stored procedures-sql-editor. When clicking on OK I got the message: "Cannot focus a disabled or invisible window." It took me some time to find out that the reason was a mistake in the code (that happened to me a couple of times).

BEGIN
DECLARE Result CURSOR WITH RETURN FOR Stmt;
....
==> DECLARE iMahnfristInkasse Integer;  <== Mistype here (Inkasse 
instead of Inkasso)
PREPARE Stmt FROM
'select Mahnfrist1, mahnfrist2, mahnfrist3, mahnfristinkasso
from Optionen';
Open Result;
....
Fetch First from Result(Mahnfrist3) into iMahnfrist3;
==> Fetch First from Result(MahnfristInkasso) into iMahnfristInkasso; 
<== correct
END



Comments Comments
Could not reproduce the "cannot focus" error, but did receive an AV when compiling/executing the procedure, which has been fixed.


Resolution Resolution
Fixed Problem on 3/23/2008 in version 1.09 build 1


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