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 <[email protected]> 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
