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

> 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
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

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