SQL Access Query
I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the word "Udate"
Why would that be?
CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL, CompanyName CHAR (50) NOT NULL, Address CHAR (50) NOT NULL, City CHAR (20) NOT NULL, State CHAR (2), Postalcode CHAR (5) NOT NULL, Areacode CHAR (3), Phonenumber CHAR (8) NOT NULL UNIQUE, CONSTRAINT ToyFK FOREIGN KEY (ToyID) REFERENCES Toy (ToyID) ON UPDATE CASCADE ON DELETE CASCADE );
Software/Hardware used:
MS2000, AS400, Access 2000
Why would that be?
CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL, CompanyName CHAR (50) NOT NULL, Address CHAR (50) NOT NULL, City CHAR (20) NOT NULL, State CHAR (2), Postalcode CHAR (5) NOT NULL, Areacode CHAR (3), Phonenumber CHAR (8) NOT NULL UNIQUE, CONSTRAINT ToyFK FOREIGN KEY (ToyID) REFERENCES Toy (ToyID) ON UPDATE CASCADE ON DELETE CASCADE );
Software/Hardware used:
MS2000, AS400, Access 2000
ASKED:
February 16, 2010 11:00 AM
UPDATED:
February 16, 2010 6:22 PM
Answer Wiki:
I spelled the work update incorrectly in the question but in the statement it is spelled correctly.
To see all answers submitted to the Answer Wiki: View Answer History.
it is eary! The word is word not work.
Hi CompEng.
You asked this question a couple of weeks ago.
Here’s the link to your first question:
SQL for MS Access Syntax issue
Is there something you want to add to the discussion ?
So does that mean that I need to use the Visual Basic or the Module side of the Access? If that were so would I just copy the answer into the module screen?
Yes, just copy the suggested code, and press the ‘run’ button.