Icon View Incident Report

Serious Serious
Reported By: Ralf Bieber
Reported On: 9/2/2007
For: Version 1.05 Build 2
# 2442 Expressions in the RAISE Statement Cause and Compile Error or Access Violation

Error by using the function ERRORMSG().

CREATE PROCEDURE "Archiv" ()
BEGIN
start transaction;
begin

...

commit;
exception
rollback;
RAISE ERROR CODE 10000 MESSAGE 'Error: '+ERRORMSG();
end;
END


###############################
================================================================================
SQL Error (ElevateDB 1.05 Build 2)
================================================================================

ElevateDB Error #700 An error was found in the statement at line 71 
and column
41 (Expected ; but instead found +)
###############################

CREATE PROCEDURE "Archiv" ()
BEGIN
start transaction;
begin

...

commit;
exception
rollback;
RAISE ERROR CODE 10000 MESSAGE ERRORMSG();
end;
END


###############################
================================================================================
SQL Error (ElevateDB 1.05 Build 2)
================================================================================

ElevateDB Error #700 An error was found in the statement at line 71 
and column
32 (Invalid expression ERRORMSG found, exception handling statements 
and
functions not allowed)
###############################

CREATE PROCEDURE "Archiv" ()
BEGIN
declare ers clob;
start transaction;
begin

...

commit;
exception
rollback;
set ers =ERRORMSG(); 
RAISE ERROR CODE 10000 MESSAGE concat('Error: ', ers);
end;
END


###############################
Execute is OK, but if the procedure runs a error-message box is 
shown:
Remote:
'ElevateDB Error #9999 Access violation at address 0051D5C5 in module 'edbsrvr.
exe'. Read address 00000088.
Local
'Access violation at address 
005505C5 in module 'edbmgr.exe'. Read address 00000088.

###############################



Resolution Resolution
Fixed Problem on 9/4/2007 in version 1.06 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