problem with where statement...

[Guest_imported]

hi there, i'm currently trying to create a sql query in visual basic but however it is giving me some problem..
'
Dim mydata As String
searchSQL = "select Daily, Earning from ProgressChart "
searchSQL = searchSQL & "where Daily =" & mydata
'
i tink the problem is that when u use the where statement.. the criteria needs to hav a ' '...
pls kindly help me with the problem...

 

[Gundapaneni]

You must provide the single quote "'" if U use string type data

so write as,
searchSQL = searchSQL & "where Daily ='" & mydata & "'"

instead of
searchSQL = searchSQL & "where Daily =" & mydata


Madhu.