Add Regex string to database

Question

Hello, I have a regex string (near 500 characters) so I created a table for it, since Short String is up to 255 chars I set it to Long String (Memo)
But I can't add it to the db:

OleDb.OleDbCommand("UPDATE MyData SET RegexString = '" + vRegexString + "'", MyConnection)

Syntax error (missing operator) in query expression ''^(([....

Well how can a regex get saved due to its varying chars?
Thank you for helping :)

Answer 1

It seems that you are using the unrecommended and dangerous string concatenation. Try using parameterised queries, something like this:

Dim cmd = new OleDb.OleDbCommand("UPDATE MyData SET RegexString = ?", MyConnection)  
cmd.Parameters.AddWithValue( "s", vRegexString)  

There are more approaches that are described in documentation.