ACC2000: CREATE CONSTRAINT Clause Help Example Missing a Parenthesis

ID: Q237852

The information in this article applies to:

Microsoft Access 2000

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)

REFERENCES

For more information about the Constraint clause, click Microsoft Access Help on the Help menu, type constraint clause (microsoft jet sql) in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: pra constraint syntax doc error

Keywords : kbdocerr kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug