I think just like you, I don't find the problem arrgggg It'll probably be some other moron thing I've missed as always xD Thanks
Nico Callewaert escribió: > 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 > > ------------------------------------------------------------------------- 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
