Subject Re: [firebird-support] Re: Firebird 2.5 (64 bit), strange SQL result
Author Alexandre Benson Smith
Em 9/5/2012 00:00, trskopo escreveu:
> Thanks for your reply.
> I think my database is in problem, because when I tried to restored it, I got error
> Engine Message :
> validation error for column ID_DIV_LC, value "*** null ***"
> warning -- record could not be restored
> I think, may be there is a leak in Firebird to trap an error when null value allowed to store in a not null value definition. I forgot how to insert this null value to the database.
> Thanks and regards,
> Sugiarto


As said before, in the beginning the colunm allows null, you insert some
records with null on that column, then you changed the column to be not
null, since it's not null the back-up won't restore.

You need to provide some value for a column that allows null when you
change it to not null

see you !