Using Microsoft SQL server as my Database
I've been trying to Save a Record containing an Approstophe,Using an INSERT Statement and it is always coming up with an Error Message "Invalid Character Near ...."
Dim conn as new AdoDB.Connection
conn.open("dsn=MyDatabase") 'Opening Connection
Dim mario as String
mario ="God's Property"
conn.Execute ("INSERT into MyTable (Description)values('"& mario &"')")
The above Code is what I use and how I've been using it. I would Appriciate Any Comments,Suggestions from Any body in House.
Thanks and Bye.