Subject ISQL issue - Comments cause errors
Author Robert & Nerine Clemenzi
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