Hi Jose, I copied everything in a little SQL script and I have no problem to run it (except for the trigger, the generator TBFIBRAOPTICA_IDFO_GEN is missing). But for the rest, I can create the foreign key without any problem. The syntax is correct.
Regards, Nico -----Oorspronkelijk bericht----- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Jose Perez Verzonden: dinsdag 27 november 2007 10:45 Aan: For users and developers of the Firebird .NET providers Onderwerp: Re: [Firebird-net-provider] Problem witch foreign key 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! Nico Callewaert escribió: > Hi Jose, > > Can you mail the complete SQL statemtn for the table creation ? > > Thanks, Nico > > -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Namens Jose > Perez > Verzonden: dinsdag 27 november 2007 10:15 > Aan: firebird-net-provider@lists.sourceforge.net > Onderwerp: [Firebird-net-provider] Problem witch foreign key > > Hi there. I'm a very beginner with Firebird, and the fist time posting > on the list, so .. hi there again to you all. > I have a problem i can't resolve. I have two tables: > > TBFO > IDFO (integer autoincrement) > Circuito (VarChar(50)) > Tipo (VarChar(50)) > Longitud (integer) > idUO (VarChar(50)) > > TBVIAL > tbVial > idUO (VarChar(50)) > ... > ... > ... > ... > > And I'm tryin to make the foreign key idUO in tfFO, but it says to me : > Error!! > Violation of FOREIGN KEY constraint "" > Violation of FOREIGN KEY constraint "INTEG_83" on table "TBVIAL" > Foreign key reference target does not exist. > > Anyone knows why is this happening?? > Thanks in advance. > > ------------------------------------------------------------------------ > - > 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 > > ------------------------------------------------------------------------- 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
