Subject Re: [firebird-support] Re: Non null column, before insert trigger not filling column, Delphi
Author Martijn Tonies
>>> Firebird
> Spooky. I've tested on Windows with and on Linux with
> (exactly the same as yours) and both fail to run the script.
> Hmmm.
> SQL> input test.sql;
> Statement failed, SQLCODE = -607
> unsuccessful metadata update
> -Column: ID not defined as NOT NULL - cannot be used in PRIMARY KEY
> constraint definition
> After line 7 in file test.sql
> Now I'm really puzzled!

Why? A primary key requires non-null columns.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: