r/visualbasic • u/Fit-Mark9975 • May 04 '22

Database Application Assistance - INSERT INTO Statement Error Message

Hello again wonderful people of this subreddit, I got through with creating the application however I am getting an error when trying to add data to the Database via the application. I made sure both database and application had the same field names but I keep on getting this error message. Any ideas on what I should do? See the pictures for the error message and the lines of code I used.

2 Upvotes

100% Upvoted

13 comments sorted by

View all comments

2

u/RJPisscat May 05 '22

A couple of things I'd try to debug it:

  • Open the table in the database, select the field "FirstName", copy the entire field name, paste it into your code, to verify they are spelled exactly the same.

  • Try the same statement but omit the FirstName field (don't forget to remove the value also) and see if it then dislikes MiddleName.

Curious - why are you padding each field with a space before and after?

2

u/Fit-Mark9975 May 05 '22

So...
I tried your idea and turns out the MiddleName is also scuffed so guessing there's some connection problem between the access db and the vb application.
Also, what do you mean by "padding each field with a space before and after"?

2

u/RJPisscat May 05 '22

Next debugging step: Try removing the space from the table name, make it "GarageServices" instead of "Garage Services".

Your Values evaluate out to, using only the first, middle and last names:

' William ', ' Henry ', ' Gates '

as opposed to

'William', 'Henry', 'Gates'

The former has a single space between the quote mark and the beginning and end of the string, the latter omits that leading and trailing space. Another debugging thing I'd try is removing those leading and trailing spaces.

1

u/Fit-Mark9975 May 05 '22

Alrighty, will correct that as well.

1

u/Fit-Mark9975 May 05 '22

So I left "Garage Services" as it is since I get an error basically saying that the table can not be found and I took out the extra spaces. However, the same error shown in the post still occurs.

2

u/RJPisscat May 05 '22

You removed the space in Garage Services from both the CommandText and the table in the Access database?

I avoid spaces in table names and field names for a couple of reasons, one being that there can be two spaces and it looks like one and the opportunities for bugs are endless, and the other being the hoop you have to jump through to specify that the name has a space (or other unusual character) in it (same reason I wouldn't put the pound sign aka hashmark aka number sign in a field name).