Reported By: Tiago Ameller Reported On: 11/27/2008 For: Version 2.02 Build 3
# 2851Reverse-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
ResolutionFixed Problem on 11/30/2008 in version 2.02 build 4
Products AffectedElevateDB Additional Software and Utilities