Re: Interbase script anomalies

[Brian_Mahoney@krinfo.com (Brian Mahoney)]

     It is pathetically likely that you need a semicolon (;) after the
     password.  I had a similar problem with a totally valid statement,
     and it went away by explictly terminating the User and password line
     with ;

     I shouldn't have had to do it.

--
______________________________ Reply Separator _________________________________
Subject: Interbase script anomalies
Author:  cpb-thread@zdtips.com at Internet
Date:    8/28/97 7:13 AM


Hello everyone
                Thanks for all your database advice - I am using the single user
Interbase to develop my app at the moment and its wonderful. However I have
noticed some anomalies when running SQL script files..


When I run this file to create the necessary domains for my database the
two entries I have commented are not  created, however I can create them
manually in the dynamic SQL window....Any ideas as to why this is, I can't
see any obvious grammar errors and the file was written all in one go and
does not generate any errors when I run it......I'm bemused

/* 27/8/97 domains for NI database
mostly works !!!
*/

CONNECT "c:\Program Files\Borland\Intrbase\NI\NI.gdb" USER "ADMIN" PASSWORD
"****"

CREATE DOMAIN IDNO AS SMALLINT NOT NULL; /* this domain is not created */
CREATE DOMAIN CODE AS CHAR(4) NOT NULL;  /* neither is this one */
CREATE DOMAIN TELNO AS VARCHAR(20);
CREATE DOMAIN SHORTTEXT AS VARCHAR(50);
CREATE DOMAIN MEDTEXT AS VARCHAR(100);
CREATE DOMAIN LONGTEXT AS VARCHAR(200);
CREATE DOMAIN POSTCODE AS VARCHAR(10);
CREATE DOMAIN BOOL AS CHAR(1) CHECK ((VALUE='0') OR (VALUE = '1'));


David Reed

                     NewsIndex