Question for ADO control(VB6)

來源: mma2001 於 2004-01-15 23:56:00 [] [舊帖] [給我悄悄話] 閱讀數 : (312 bytes)
本文內容已被 [ mma2001 ] 在 2004-02-06 15:24:48 編輯過。如有問題，請報告版主或論壇管理刪除.

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--
請您先登陸，再發跟帖！