Hello everybody

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?

Thanks in advance.

Walter.


[Non-text portions of this message have been removed]