From my QC department. I am not very good with source forge, so if
someone could check to see if this is logged yet, that would be great.

Here are the two view scripts. The first has a comment line with an
apostrophe or single quote and when run, the view is not created. The
second has a comment line with no apostrophe and the view is created
fine.

/* comment lines don't work with an apostrophe*/
CREATE VIEW GL_SCF_CODE_RPT_V
AS SELECT
GL_SCF_CODE.CODE_ID ,
GL_SCF_CODE.CODE_DESC ,
GL_SCF_CODE.CODE_DESC_SORT ,
GL_SCF_CODE.CODE_INACTIVE ,
GL_SCF_CODE.NOTE_PAD ,
GL_SCF_CODE.MOD_USER_ID ,
GL_SCF_CODE.MOD_DATE ,
GL_SCF_CODE.MOD_TIME
FROM
GL_SCF_CODE;

/* comment lines do work without an apostrophe*/
CREATE VIEW GL_SCF_CODE_RPT_V
AS SELECT
GL_SCF_CODE.CODE_ID ,
GL_SCF_CODE.CODE_DESC ,
GL_SCF_CODE.CODE_DESC_SORT ,
GL_SCF_CODE.CODE_INACTIVE ,
GL_SCF_CODE.NOTE_PAD ,
GL_SCF_CODE.MOD_USER_ID ,
GL_SCF_CODE.MOD_DATE ,
GL_SCF_CODE.MOD_TIME
FROM
GL_SCF_CODE;





--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com



[Non-text portions of this message have been removed]