Microsoft KB Archive/237852

= ACC2000: CREATE CONSTRAINT Clause Help Example Missing a Parenthesis =

Article ID: 237852

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q237852



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
In the "CONSTRAINT Clause (Microsoft Jet SQL)" topic of the Microsoft Access Help system, the example in the fourth bulleted item in the "Remarks" section is incorrect. The example, which reads as follows, is missing a parenthesis at the end:   CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER,    OrderNotes NCHAR VARYING (255), CONSTRAINT FKOrdersCustId FOREIGN KEY    (CustId) REFERENCES Customers ON UPDATE CASCADE ON DELETE CASCADE



RESOLUTION
Add a closing parenthesis to the end of the example, as follows:   CREATE TABLE Orders (OrderId INTEGER PRIMARY KEY, CustId INTEGER,    OrderNotes NCHAR VARYING (255), CONSTRAINT FKOrdersCustId FOREIGN KEY    (CustId) REFERENCES Customers ON UPDATE CASCADE ON DELETE CASCADE)

