Standard INSERT statement is not working in Express Web Developer?
Hey Everyone,
I am going through a beginning tutorial on making a sql database with asp -- the article to right click on the dbase and add New Query - then select from the dbase, etc. etc. those all worked fine.
HOWEVER, it then tells me to insert a row -- it all looks standard and should work (here is what it says):
Try running an INSERT query to insert a new row in the quotes table:
INSERT (Author, Quote) INTO Quotes VALUES ('Me', 'Life is good!')
But I get an error that reads:
SQL Execution error
Error Sourse .NetSql Data Provider
Error Message: Incorrect Syntax near '('.
Any help on this one?