Hey , am currently doing my school project of coming up with school reports of learners but when I tried to connect my database with the ms vb it gave me an insert into error whil I was trying to register learners .Please help.
Lucky_8
0
Newbie Poster
Recommended Answers
Jump to PostTypically, when you do an
INSERT
you include some values to go with the field names. For exampleINSERT INTO mytable (LastName,FirstName,Age) VALUES('Smith','George',27)
Your query didn't do this.
I'll also add that you should be using Parameterized Queries.
All 3 Replies
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Lucky_8
0
Newbie Poster
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.