Subject | RE: [firebird-support] Database update problem |
---|---|
Author | Thomas Steinmaurer |
Post date | 2004-09-23T10:16:51Z |
Hi,
using Firebird 1.5?
Being able to store NULL in an UNIQUE INDEX / CONSTRAINT
is a new feature in Firebird 1.5.
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com
> My program run database modification scripts (containing lots ofIs your customer running Firebird 1.0, whereas you are
> changes) in client computer.
> Client reports that he gets this error during update:
> ISC ERROR: 335544349
> Attempt to store duplicate value (...) in unique index
> "RDB$PRIMARY43"
> Null segment of UNIQUE KEY
>
> I obtained his database and tried it on my computer: everything works
> OK?!?
>
> What can be problem with this kind of different behaviour?
> And what does this error mean - am I entering some duplicate NULL values
> into index or....?
using Firebird 1.5?
Being able to store NULL in an UNIQUE INDEX / CONSTRAINT
is a new feature in Firebird 1.5.
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com