Yeah yeah I know, thanks Helen Borrie escribió: > 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 > >
------------------------------------------------------------------------- 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
