Hi Mike,

You have a problem with your pseudocode, not null is supported, as in the
following metadata extract taken from a working Firebird DB

CREATE TABLE PACKAGING (
CODE VARCHAR(30) NOT NULL,
DESCRIPTION VARCHAR(50) NOT NULL);

Regards,
John.

----- Original Message -----
From: "rimovm" <rimovm@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, February 28, 2002 12:53 PM
Subject: [ib-support] null vs not null field syntax?


> Platform: Firebird RC2
>
> Hello all!
>
> Been working to finally getting to the latest firebird, etc, and came
> across some code in a code library that basically issued the
> statement: (pseudocode)
>
> CREATE TABLE(FieldName VARCHAR(80) not null, FieldName2 VARCHAR(30)
> null);
>
> Firebird was dying on the "not null" part of the statement. And
> whoever put it into the code library had the note: "SQL-92 Standard?"
>
> I started to look through the spec and just got glazed over rather
> quickly and never found whether "not null" is part of the spec. So
> what I'm asking is:
>
> 1 - Do any of your SQL-92 gurus know whether it is or it isn't?
>
> 2 - If it is, is it worthwhile to report it as a conformance bug?
>
> Thanks!
> -Mike
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>