Hi, Are you using Vs2005 + FBClient 2.5.1 without the problem below? Thanks, Rogerio
________________________________ > From: rogeriobett...@hotmail.com > To: firebird-net-provider@lists.sourceforge.net > Subject: Failed to add relation(s) > Date: Sun, 10 Jan 2010 16:45:20 +0000 > > > > > > > > > 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 Explorer > Data Connections > MyConnection > Tables > |---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
