SQL Like Query with a variable as parameter in VB 6.0

[vineelaapt]

Iam using SQL LIKE Query to add items run time to a combo Box.
I used the code as:

Dim EMPNAME As String
EMPNAME = TXTNAME.Text & "%"
Set RST = Nothing
Dim I As Integer
RST.Open "Select * from TAB_EMP_DETAILS where emp_name like '" &empname & "'", CON, 1, 2
I = 0
While Not RST.EOF
CMBNAME.AddItem RST("EMP_NAME"), I
CMBNAME.ItemData(I) = RST(0)
I = I + 1
RST.MoveNext
Wend
RST.Close

But the problem even though records are there it is showing EOF true and coming out of the loop without adding anything into combo box.

Please solve this problem urgently............................

[scripto]

Iam using SQL LIKE Query to add items run time to a combo Box.
I used the code as:

Dim EMPNAME As String
EMPNAME = TXTNAME.Text & "%"
Set RST = Nothing
Dim I As Integer
RST.Open "Select * from TAB_EMP_DETAILS where emp_name like '" &empname & "'", CON, 1, 2
I = 0
While Not RST.EOF
CMBNAME.AddItem RST("EMP_NAME"), I
CMBNAME.ItemData(I) = RST(0)
I = I + 1
RST.MoveNext
Wend
RST.Close

But the problem even though records are there it is showing EOF true and coming out of the loop without adding anything into combo box.

Please solve this problem urgently............................

Well, there's no way I can verify your SQL connection, so, assuming that your connection is valid and you did set RST as a ADODB.Recordset (it's currently set to nothing???), one possible problem COULD be that you have a space(s) in the textbox.
Give this a try:

EMPNAME = trim(TXTNAME.Text) & "%"

[Killer42]

Well, there's no way I can verify your SQL connection, so, assuming that your connection is valid and you did set RST as a ADODB.Recordset (it's currently set to nothing???), one possible problem COULD be that you have a space(s) in the textbox.
Give this a try:

EMPNAME = trim(TXTNAME.Text) & "%"

I find this surprising...

RST.Open "Select * from TAB_EMP_DETAILS where ...

I would have expected it to be done via the database.CreateRecordset method (or is it OpenRecordset?). On the other hand, there are so many different ways of doing these things...