0
newUserCommand.CommandText = "INSERT INTO users(username, password, security) VALUES('" & newUserNameBox.Text & "';'" & newPassWordBox.Text & "';" & newUserSecurityBox.Text & ";'"

I cannot find where the syntax error is but vstudio tells me the error is in a unclosed quotation after ;

1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by AaronDickey
0
newUserCommand.CommandText = "INSERT INTO users(username, password, security) VALUES('" & newUserNameBox.Text & "';'" & newPassWordBox.Text & "';" & newUserSecurityBox.Text & ";'"

I cannot find where the syntax error is but vstudio tells me the error is in a unclosed quotation after ;

Found it never mind. Thank you.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.