Member Avatar for AaronDickey 
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
  • 137 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by AaronDickey
Member Avatar for AaronDickey 
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.

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.