Foreign Keys On SQLServer
Foreign Keys On SQLServer
- Subject: Foreign Keys On SQLServer
- From: "Riaz Lalehzari" <email@hidden>
- Date: Tue, 25 Feb 2003 01:23:02 +0000
Hello there...
I have some many-to-many relationships (using the standard join table,
flattening etc). All relationships are done on the EOModel and I have not
made any changes to the actual database (it's basically a list of tables
without relationships). When I try to generate the sql for the model, when
it gets to the 'ALTER TABLE section that specifies foreign key details it
has a problem - Below is the error...
Error from JDBC adaptor: EvaluateExpression failed:
<MicrosoftPlugIn$MicrosoftExpression: "ALTER TABLE
dbo.ApplicationFunctionSecurityGroup ADD CONSTRAINT
dbo.ApplicationFunctionSecurityGroup_securityGroup_FK FOREIGN KEY
(SecurityGroupID) REFERENCES dbo.SecurityGroup (ID)">:
Next exception:SQL State:HY000 -- error code: 170 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 1: Incorrect
syntax near '.'.......
I've seen other people having the same problem on the mailing list but there
were no answers posted that I could find.
As always, thanks for the assistance.
Riaz
_________________________________________________________________
MSN Instant Messenger now available on Australian mobile phones. Go to
http://ninemsn.com.au/mobilecentral/hotmail_messenger.asp
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.