Subject | rare problem |
---|---|
Author | Sergio H. Gonzalez |
Post date | 2011-06-23T13:53:28Z |
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]
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]