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 On Thu, Jun 21, 2012 at 9:28 AM, Jiri Cincura <disk...@cincura.net> wrote: > Do you have reproducible test case? > > -- > Jiri {x2} Cincura (x2develop.com founder) > http://blog.cincura.net/ | http://www.ID3renamer.com > > ------------------------------------------------------------------------------ > 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 ------------------------------------------------------------------------------ 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