Helen,

For example, for not creating test datas, I comment the line INPUT
TESTDATAS.SQL;

If I do this, I getthe following error:

-- INPUT TESTDATAS.SQL; /* Insert some test data */
Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Unexpected end of command

I obtain the same result if I comment out the SET NAMES line:
--SET NAMES ISO8859_1;
Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Unexpected end of command


Regards,
Fabrice

=========================create_db.sql==============================
/* Create database */
CREATE DATABASE 'Controller.gdb'
USER 'SYSDBA'
PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET ISO8859_1
;

COMMIT;

SET NAMES ISO8859_1;

CONNECT 'Controller.gdb'
USER 'SYSDBA'
PASSWORD 'masterkey'
;

INPUT DOMAINS.SQL; /* Create domains */
INPUT TABLES.SQL; /* Create tables & PK */
INPUT VIEWS.SQL; /* Create views */
INPUT INDEXES.SQL; /* Create indexes & FK */
INPUT TRIGGERS.SQL; /* Create triggers */
INPUT PROCS.SQL; /* Create stored procedures */
INPUT GRANTS.SQL; /* Security */
INPUT DATAS.SQL; /* Insert default data */

-- INPUT TESTDATAS.SQL; /* Insert some test data */

QUIT;
====================================================================

--- In ib-support@y..., Helen Borrie <helebor@d...> wrote:
> At 01:48 PM 15-11-01 +0000, you wrote:
> >Hi,
> >
> >Has anyone already played with the new -- comments?
> >
> >When I put -- comments anywhere into the following create_db.sql,
I
> >got an error -104. However, it seems to be OK in the sub-scripts
> >(tables.sql f.e.)
> >
> >It does not cause a big trouble, just strange.
>
> Can you provide an example of how you used it? (Couldn't see one
in your sample script).
>
> Helen
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________