> I have a table called DEPARTMENTS
>
> - It had a primary key with the columns CODSUC and CODLOC
> - I had droped the primary key
> - I had added a new column, called IDENTI
> - I had filled the column IDENTI with different values
> - I want to have a new primary key, with the column IDENTI
> - But it is impossible, the message: 'validation error for column IDENTI,
> value "*** null ***"' appears
> - Writing:
> SELECT IDENTI FROM DEPARTMENTS
> shows me that there are not null values
> - I did a GBAK -backup and a GBAK -create
> - I had used the new database
> - However, the same error appears when I try to create a new primary key
> with the column IDENTI
>
> Why that? Which is the solution? Do you know?

Is the new field declared as NOT NULL?


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!