Subject | -- Comment |
---|---|
Author | Fabrice Aeschbacher |
Post date | 2001-11-15T13:48:54Z |
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.
=========================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;
====================================================================
(FB1.0.0 RC1)
Regards,
Fabrice
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.
=========================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;
====================================================================
(FB1.0.0 RC1)
Regards,
Fabrice