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
