[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

VS 2008 Web Developer

I am new to Visual Studio Web Developer 2008. Can any one tell me why the very simple insert query gives me an error, please see attached file.
VSerr.jpg
0
rbrindisi
Asked:
rbrindisi
  • 2
1 Solution
 
ezraaCommented:
you need to put the values in quotes:
Insert into table (field) values ("value")
0
 
ezraaCommented:
corrected code:
insert into Table1 (city, state, country) values ('lodi','nj','usa')

Open in new window

0
 
rbrindisiAuthor Commented:
That worked, thank you.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now