On 2012.06.21 10:44 AM, Sener DEMIRAL wrote: > CREATE TABLE AAA ( > A1PK INTEGER NOT NULL, > A2 INTEGER, > A3 INTEGER > ); > ALTER TABLE AAA ADD CONSTRAINT PK_AAA PRIMARY KEY (A1PK); > > CREATE TABLE BBB ( > B1PK INTEGER NOT NULL, > A1PK INTEGER NOT NULL, > B2 INTEGER, > B3 INTEGER > ); > ALTER TABLE BBB ADD CONSTRAINT PK_BBB PRIMARY KEY (B1PK); > ALTER TABLE BBB ADD CONSTRAINT FK_BBB_1 FOREIGN KEY (A1PK) REFERENCES > AAA (A1PK); > > VS 2010 > AddNewDataSource > Add table AAA > Add table BBB > > Failed to add TableAdapter > Object reference not set to an instance of an object > > > *********** > * Hint * > *********** > With following definitions it works. Attention to PK/FK field names > > CREATE TABLE AAA ( > A1 INTEGER NOT NULL, > A2 INTEGER, > A3 INTEGER > ); > ALTER TABLE AAA ADD CONSTRAINT PK_AAA PRIMARY KEY (A1); > > CREATE TABLE BBB ( > B1 INTEGER NOT NULL, > A1 INTEGER NOT NULL, > B2 INTEGER, > B3 INTEGER > ); > ALTER TABLE BBB ADD CONSTRAINT PK_BBB PRIMARY KEY (B1); > ALTER TABLE BBB ADD CONSTRAINT FK_BBB_1 FOREIGN KEY (A1) REFERENCES AAA (A1); > > Server 2.5.1.26351 > Client v6.3.1.26351 > ODS version 11.2 > > Sener > Have tried to set description as #PK_GEN# for primary key?
Regards, Paul MERCEA ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
