database.Tables("Table1").Select("value='" & "t'h'i's i's t'h'e v'a'l'u'e" & "'")(0)
this select statement dosn't work because the selection string has single quotes in it. how can i fix this error. the db value i want to select has quotes in it.
Printable View
database.Tables("Table1").Select("value='" & "t'h'i's i's t'h'e v'a'l'u'e" & "'")(0)
this select statement dosn't work because the selection string has single quotes in it. how can i fix this error. the db value i want to select has quotes in it.
i got it:
selectByThisValue.tostring.replace(" ' "," ' ' ")
(without the spaces)