Subject RE: [firebird-support] Database update problem
Author Thomas Steinmaurer
Hi,

> My program run database modification scripts (containing lots of
> 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....?

Is your customer running Firebird 1.0, whereas you are
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