Well ... the problem is with EMS I guess. I've tried Ibaccess and it's 
done. EMS sucks !!

Jose Perez escribió:
> Yeah, it could probably be that. I have no time right now to check it 
> but as soon as I do it I'll let you know.
> Thanks.
>
> Julio Saucedo escribió:
>> Hola Jose,
>>
>> I think that the problem is in your data, maybe you have some record 
>> with a value in the field that you
>> want to be the FK, having a value that is not in the foreign table. I 
>> think that is what means the message
>> "Foreign key reference target does not exist". You could first 
>> identify the record(s) and set a null value or
>> some other value that effectively is in the foreign table, in the 
>> field for the FK.
>>
>> Best regards.
>>
>> Julio Saucedo.
>>
>>  
>>> 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
>>>
>>>       
>>
>>
>> ------------------------------------------------------------------------- 
>>
>> 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
>>
>>   
>
>


-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to