Subject rare problem
Author Sergio H. Gonzalez
hello!

I have this table, with 5 records:

CREATE TABLE FAC_VEN_SUC (
ID ID /* ID = NUMERIC(9,0) NOT NULL */,
SUCURSAL ID /* ID = NUMERIC(9,0) NOT NULL */,
LETRA CARACTER NOT NULL /* CARACTER = CHAR(1) */,
NUMERO NUMERO_DOC /* NUMERO_DOC = NUMERIC(18,0) DEFAULT 0 */,
EMITIENDO BOOLEAN /* BOOLEAN = SMALLINT default 0 CHECK (value
is null or value in (0, 1)) */,
ID_EMPRESAS ID /* ID = NUMERIC(9,0) NOT NULL */,
ALERTA NUMERO_DOC /* NUMERO_DOC = NUMERIC(18,0) DEFAULT 0 */,
SIGNO NUMERO_CHICO /* NUMERO_CHICO = SMALLINT DEFAULT 0 */
);

ID has the values from 1 to 5, but when I try to create a PK on ID I get
this:

The insert failed because a column definition includes validation
constraints.
validation error for column ID, value "*** null ***".

How is it possible? Just in case, I'm using FB 2.5

thanks!!!!

-s


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