Subject | ISQL issue - Comments cause errors |
---|---|
Author | Robert & Nerine Clemenzi |
Post date | 2005-02-23T18:55:27Z |
I am running isql.exe 7-14-04
Using the /* ... */ syntax to add comments, the following example fails.
The issue is related to the number of characters between the delimiters
and to the fact that the last line of the comments is
/* */
************
I right click *.sql files and select a menu option to run them using
cmd.exe /k ""C:\Program Files\Firebird\Firebird_1_5\bin\isql.exe" -i "%l""
Most sql files run fine, however, this file fails
<-- start of file -->
Connect 'E:\NIST\Main Database\FB Databases 2005-02-11\Samples.fdb' USER
'SYSDBA' PASSWORD 'masterkey';
/* Data entered 02-22-05 - rlc
used in Sample_Timeline_tbl to indicate the type of data
CREATE TABLE "Data_Type_LU" (
"Data_Type_ID" "Domain_ShortString_IDs" NOT NULL,
"Data_Type_Text" "Domain_Short_Descriptions",
"Comment" VARCHAR(200)
);
/* */
<-- end of file -->
with this error
Use CONNECT or CREATE DATABASE to specify a database
Command error: /* Data entered 02-22-05 - rlc
used in Sample_Timeline_tbl to indicate the type of data
CREATE TABLE "Data_Type_LU" (
"Data_Type_ID" "Domain_ShortString_IDs" NOT NULL,
"Data_Type_Text" "Domain_Short_Descriptions",
"Comment"
******
If the comment is shortened to 7 lines, it does not fail
Also, if the last line of the comment is changed from
/* */
to
/*
*/
(ie, place a return between the 2 asterisks)
there is no failure.
This took about 5 hours to track down.
Robert Clemenzi
Using the /* ... */ syntax to add comments, the following example fails.
The issue is related to the number of characters between the delimiters
and to the fact that the last line of the comments is
/* */
************
I right click *.sql files and select a menu option to run them using
cmd.exe /k ""C:\Program Files\Firebird\Firebird_1_5\bin\isql.exe" -i "%l""
Most sql files run fine, however, this file fails
<-- start of file -->
Connect 'E:\NIST\Main Database\FB Databases 2005-02-11\Samples.fdb' USER
'SYSDBA' PASSWORD 'masterkey';
/* Data entered 02-22-05 - rlc
used in Sample_Timeline_tbl to indicate the type of data
CREATE TABLE "Data_Type_LU" (
"Data_Type_ID" "Domain_ShortString_IDs" NOT NULL,
"Data_Type_Text" "Domain_Short_Descriptions",
"Comment" VARCHAR(200)
);
/* */
<-- end of file -->
with this error
Use CONNECT or CREATE DATABASE to specify a database
Command error: /* Data entered 02-22-05 - rlc
used in Sample_Timeline_tbl to indicate the type of data
CREATE TABLE "Data_Type_LU" (
"Data_Type_ID" "Domain_ShortString_IDs" NOT NULL,
"Data_Type_Text" "Domain_Short_Descriptions",
"Comment"
******
If the comment is shortened to 7 lines, it does not fail
Also, if the last line of the comment is changed from
/* */
to
/*
*/
(ie, place a return between the 2 asterisks)
there is no failure.
This took about 5 hours to track down.
Robert Clemenzi