Gracias de nuevo, pero me da error al crear la tabla con el campo computed.
Me dice expression evaluation no supported.
Esta es la creacion de la tabla
Código SQL
[-]
CREATE TABLE "CTR0003"
(
"DORSAL" INTEGER,
"DORSAL2" INTEGER,
"COGNOM1" VARCHAR(25) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"COGNOM2" VARCHAR(25) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"NOM" VARCHAR(20) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"CODI_CAT" INTEGER,
"NACIO" VARCHAR(3) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"LLICENCIA" VARCHAR(14) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"DNI" VARCHAR(12) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"CODIUCI" VARCHAR(12) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"CODI_CLUB" INTEGER,
"CLUB" VARCHAR(25) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"ABR_CLUB" VARCHAR(3) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"PUBLICITAT" VARCHAR(25) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"SEXE" VARCHAR(1) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"FEDERAT" VARCHAR(1) CHARACTER SET ISO8859_1 COLLATE ES_ES,
"DATA_NAIX" DATE,
"EDAT" COMPUTED BY (EXTRACT(YEAR FROM 'NOW' - DATA_NAIX)),
"CATEGORIA" VARCHAR(5) CHARACTER SET ISO8859_1 COLLATE ES_ES
);
Mi Firebird es 1.5
Saludos
Josep