At 08:40 PM 27/11/2007, you wrote: >I'm using EMS SQL studio nad here is what the sql statement he does to >create the tables: > >*TBVIAL* > >CREATE TABLE TBVIAL ( > IDUO VARCHAR(50) CHARACTER SET WIN1251 NOT NULL COLLATE WIN1251, > LONGITUD VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251, > DESBROCE VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251, > EXCAVACIONROCA VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251, > EXCAVACIONTIERRA VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251, > TERRAPLENADO VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251, > ZAHORRA VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251, > CUNETATIERRA VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251, > CUNETAREVESTIDA VARCHAR(20), > SALVACUNETA VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251); > > >ALTER TABLE TBVIAL ADD PRIMARY KEY (IDUO); > >*TBFIBRAOPTICA* > >CREATE TABLE TBFIBRAOPTICA ( > IDFO INTEGER NOT NULL, > CIRCUITOFO VARCHAR(20) CHARACTER SET WIN1251 COLLATE WIN1251, > TIPOFO VARCHAR(50) CHARACTER SET WIN1251 COLLATE WIN1251, > LONGITUD INTEGER, > IDUO VARCHAR(50) CHARACTER SET WIN1251 DEFAULT '' NOT NULL COLLATE >WIN1251); > > >ALTER TABLE TBFIBRAOPTICA ADD PRIMARY KEY (IDFO); > > >SET TERM ^ ; > >CREATE TRIGGER BI_TBFIBRAOPTICA_IDFO FOR TBFIBRAOPTICA >ACTIVE BEFORE INSERT >POSITION 0 >AS >BEGIN > IF (NEW.IDFO IS NULL) THEN > NEW.IDFO = GEN_ID(TBFIBRAOPTICA_IDFO_GEN, 1); >END^ > >SET TERM ; ^ > >Then I'm trying to make de foreign key, something like: > >ALTER TABLE TBFIBRAOPTICA ADD CONSTRAINT FK_TBFIBRAOPTICA FOREIGN KEY >(IDUO) REFERENCES TBVIAL(IDUO) ON DELETE CASCADE ON UPDATE CASCADE; > >and then comes the error. > >Thanks in advance!
You must COMMIT the DDL for the tables before you try to apply foreign key constraints. Helen ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider