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

Reply via email to