Remove one NOT NULL from this row:

ACCIDENTTYPE TINTEGER NOT NULL NOT NULL,

Ivan

----- Original Message -----
From: "Joe Bain" <jbain@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, July 08, 2005 4:26 PM
Subject: [firebird-support] unsupported DYN verb


>I am getting the error 'unsupported DYN verb' when ever I try to the
> following script on an empty database. Can anyone help me out?
>
>
>
> I am running WI-V1.5.1.4481 using a local TCP/IP connection on a WinXP sp1
> box.
>
>
>
> CREATE DOMAIN CHAR1 AS CHAR(1);
>
> CREATE DOMAIN CHAR2 AS CHAR(2);
>
> CREATE DOMAIN VARCHAR10 AS VARCHAR(10);
>
> CREATE DOMAIN VARCHAR15 AS VARCHAR(15);
>
> CREATE DOMAIN TINTEGER AS INTEGER;
>
> CREATE DOMAIN TTIMESTAMP AS TIMESTAMP;
>
> CREATE DOMAIN TEXTBLOB AS BLOB SUB_TYPE TEXT SEGMENT SIZE 80;
>
>
>
> CREATE TABLE PRECLAIMINSSPECMASTER
>
> (
>
> PRECLAIMRECORDID TINTEGER NOT NULL,
>
> AGENCYCODE VARCHAR15,
>
> PRODUCERCODE VARCHAR15,
>
> ENDORSEMENTS TEXTBLOB,
>
> POLICYEFFECTIVEDATE TTIMESTAMP,
>
> POLICYEXPIRATIONDATE TTIMESTAMP,
>
> RATETERRITORY CHAR2,
>
> CHARGEABLE CHAR1 NOT NULL,
>
> ACCIDENTTYPE TINTEGER NOT NULL NOT NULL,
>
> CREATEDATE TTIMESTAMP,
>
> CREATEUSER VARCHAR10,
>
> CHANGEDATE TTIMESTAMP,
>
> CHANGEUSER VARCHAR10,
>
> PRIMARY KEY (PRECLAIMRECORDID)
>
> );
>
>
>
> ---------------------------
>
> Joe Bain
>
> IEG Inc.
>
> 405-843-8142 x224