Dim mySQL As String
Dim my As String
Dim tt As String
Set rs = New ADODB.Recordset
tt = "192.168.1.101"
mySQL = "select 暱稱 from 聊天明細 where IP like 'tt' "
rs.Open mySQL, cn, adOpenStatic, adLockOptimistic
my = rs.GetString
Text2.Text = my
我想給變數,還後從access裡抓回我要東西,這段where IP like 'tt'的tt是無效,要怎麼寫才能抓回我要的資料,而且抓回後放在變數中
arrow
arrow
    全站熱搜

    vbqa 發表在 痞客邦 留言(3) 人氣()