Unanswered: i have problem regarding SELECT query statements in VB6
i have problem regarding SELECT query statements in VB6. I want to open the record in a database. that record has an appostrophy or single quote symbol becuase it contains words with "appostrophy s". when i want to retrieve it, and place it in the textbox, there is a runtime error explains syntax error (missing operator)in the query expression = '. how to solve that runtime error. this is example of code:
Private Sub listenglish_ItemClick(ByVal Item As MSComctlLib.ListItem)
Dim rstpos As Recordset
Set rstpos = New Recordset
If rstpos.State = adStateOpen Then
rstpos.CursorLocation = adUseClient
rstpos.CursorType = adOpenDynamic
rstpos.LockType = adLockOptimistic
.ActiveConnection = mcnnproj
.Source = "SELECT english from translation where english ='" & listenglish.SelectedItem & "'"
RichTextBox1.Text = rstpos!english
Set rstpos = Nothing
my problem here is in: "SELECT english from translation where english ='" & listenglish.SelectedItem & "'"
Hope anyone will help me in this problem. i need to solve this problem immediately. thanks