Subject Re: [ib-support] Problem with insert without specifing value for DATE
Author Martijn Tonies

> Thank you for answering my post. I was really confused with case I show
> you. I haven't any triggers, checks or etc. for this table. I show you
> all DDL for it.
> I tried to execute my insert statement with InterBase Data Acces
> Components for Borland C++Builder 6 (standard components), IBExpert 2
> Trial and isql. Everyone gives me the same error message.
> I made a backup and restore my DB in another place. An attempt to insert
> into "brand new" DB was successful. The source DB with no change.
> Finally I've restarted Firebird (v1 on win2000, local machine). And...
> it helps!

Did you modify the NOT NULL flag with IBExpert?

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."