ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT
I tried example 6 from the book SQL for Microsoft Access and got the error message" CHARACTERS FOUND AT THE END OF SQL STATEMENT. I tried deleing the first semicolon and got a message: missing semicolon at end of SQL statement. Can anyone tell me what I am doing wrong?
Thanks,
INSERT INTO Toys (ToyID, ToyName, Price, Description)
VALUES (1, 'ToyTrain1', 11.00, 'Red/blue battery powered train');
INSERT INTO Toys (ToyID, ToyName, Price, Description)
VALUES (2, 'ToyTrain2', 11.00, 'Green/red/blue battery powered train');
INSERT INTO Toys (ToyID, ToyName, Price, Description)
VALUES (3, 'ElectricTrain', 15.00, 'Red/white AC/DC powered train',);
INSERT INTO Toys (ToyID, ToyName, Price, Description)
VALUES (4, 'LivingDoll1',12.00, 'Asian American Doll');
INSERT INTO Toys (ToyID, ToyName, Price, Description)
VALUES (5,'LivingDoll2', 12.00, 'AfricanAmerican Doll' );
Software/Hardware used:
Software/Hardware used:
ASKED:
June 8, 2010 5:33 PM
UPDATED:
June 8, 2010 6:08 PM
Answer Wiki:
If you are running that as a query, you can run just one SQL statement at a time (anything after the first semicolon will generate an error).
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
