Icon View Incident Report

Minor Minor
Reported By: Tiago Ameller
Reported On: 11/27/2008
For: Version 2.02 Build 3
# 2851 Reverse-Engineering Generates Incorrect SQL for VIEW WITH CHECK OPTION Clause

Reverse enginer forgets the OPTION word creating CREATE VIEW code when WITH CHECK OPTION is checked

Reverse enginer produced this erroneous code:

   EXECUTE IMMEDIATE 
'CREATE VIEW "vwExpediActual" AS
SELECT * FROM MAEXPEDI WHERE HISTORICO = FALSE 
ORDER BY HISTORICO, ANO, CODIGO

WITH CHECK 
DESCRIPTION ''Expedientes ejercicio acutal (Historico = False)''';

See missing OPTION after WITH CHECK



Resolution Resolution
Fixed Problem on 11/30/2008 in version 2.02 build 4


Products Affected Products Affected
ElevateDB Additional Software and Utilities

Image