From: <td...@te...> - 2004-04-23 20:20:02
|
Hi! I enjoy using sqlpp 2.14, because it's so easy to use :) <http://sourceforge.net/project/showfiles.php?group_id=88217&package_id=115840&release_id=232492> I still have a question. How can I implement a compositional primary key which references a foreign key from an other table? I send you a nant build script which I have made suitable for your example. Thanks Greetings Tomek ### pseudo example create table customer( customerID INT NOT NULL, customerName nvarchar(50), PRIMARY KEY (customerID) ); create table task( customerID INT NOT NULL, orderID INT NOT NULL, PRIMARY KEY (customerID,orderID), FOREIGN KEY (customerID) REFERENCES customer (customerID), ); |