I want to know what is wrong in this statement.
Dim wsd As New ADODB.Recordset
tcompname = Trim(currentnode.FullPath)
wsd.Open ("select * from Usertable where User='" & tcompname & "'"), cn, adOpenStatic, adLockOptimistic
It is always returning me EOF even when condition specified is correct. Why so. I m able to search numeric conditions, but on strings it does not work. Returns EOF,.