Adding line feeds and apostrophes to a database
I created a database in ACCESS of two fields, one a text field and the other a memo field. I can add to the database all right until I try to add a line feed or an apostrophe.
The code is:
SQL2 = "INSERT INTO tblSignData (nametbl, comtbl) VALUES ('" + myname + "',"
SQL2 = SQL2 + "'" + mycomment + "');"
adoConn.Execute(SQL2)
adoConn.close
Is there another way of writing this code so the LF and apostrohpes are accepted?
Riffaff
|
