Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
13
Reply
Syntax error in INSERT INTO statement.
Andrew
Mar 27 2010 7:09 AM
4.6k
Reply
Hi,
I have a program to communicate with database. One of the functions is to INSERT data into the database, which is giving me a syntax error!
I can't figure out why...
"INSERT INTO Report ('Date', 'Reporter', 'Details') VALUES ('27/1/2010', 'Mark Smith, 11260(S)', 'gfdsgsdfgsdf')"
I also tried it like this:
"INSERT INTO Report (Date, Reporter, Details) VALUES ('27/1/2010', 'Mark Smith, 11260(S)', 'gfdsgsdfgsdf')"
Can someone please help?
Andrew
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
13
)
Next Recommended Forum
Run the existing SQL Script programmatically with SMO
Groupbox and listbox