Question for ADO control(VB6)

RecStrB = "SELECT * FROM [UserPE_Q] where [USERID] = " & " " & userID & ""



or something like this...

RecStrA = "SELECT * FROM [Users] where [FIRSTNAME] = " & "'" & FirstName & "'" & " AND [LASTNAME] = " & "'" & LastName & "'"
Set myreca = mydb.OpenRecordset(RecStrA, dbOpenDynaset)

--文学城www.wenxuecity.com--