Hi,
I'm using VS2005 + Firebird 2.5RC1 + FirebirdClient(provider) 2.5.1 + DDEX
2.04.While trying to add a DataSource, I'm getting the following error:"Failed
to add relation(s)An item with the same key has already been added."
I can see the tables of my DB by expanding the FB connection at
ServerExplorer.Maybe this could be related: listed in my table, there are a
foreignkey(RDB$FOREIGN3) and also a constraint (INTEG_4) for the same
field(CONTRATO_TIPO). At INTEG_4, the same field is repetead a lot times. I'll
try to reproduce that blelow:Server ExplorerData
ConnectionsMyConnectionTables|---CLIENTE |--- CODIGO |---
CONTRATO_TIPO |--- RDB$FOREIGN3 |--- CONTRATO_TIPO |---
INTEG_4 |--- CONTRATO_TIPO :: (listed many times)
|--- CONTRATO_TIPO
To reproduce the fault, I used the following script:
CREATE DOMAIN CODIGO_SINT AS Smallint NOT NULL CHECK (VALUE>0);CREATE TABLE
CONTRATO ( CODIGO CODIGO_SINT NOT NULL, DESCRICAO VARCHAR(30) COLLATE PT_BR,
PRIMARY KEY(CODIGO));CREATE TABLE CLIENTE ( CODIGO CODIGO_SINT,
CONTRATO_TIPO CODIGO_SINT,PRIMARY KEY(CODIGO),FOREIGN KEY(CONTRATO_TIPO)
REFERENCES CONTRATO(CODIGO) ON DELETE NO ACTION ON UPDATE CASCADE);
Do you think that could be a bug in the provider?
Best regards,Rogerio
_________________________________________________________________
Deixe seu computador compatÃvel com a sua vida. Clique para conhecer o Windows
7!
http://www.microsoft.com/brasil/windows7/default.html?WT.mc_id=1539
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
