假若在VB端你是采用ADO連Sybase的話,就可以這樣組建動態SQL.
Dim strMy string
dim bytTest() as bytestrMy="0x"
Redim bytTest(7)
bytTest=rs.fields("TimeStamp").value 'Rs是你的Recordset,Timestamp是你的Timestamp字段。For i = 0 To 7
strMy = strMy + IIf(Len(CStr(Hex(byt(i)))) = 1, "0" + CStr(Hex(byt(i))), CStr(Hex(byt(i))))
Next這里得出來的值strMy就是TimeStamp字段的字串。然後就可以這樣寫SQL;SELECT * From YourTable WHERE TimeStamp=strMy
Dim strMy string
dim bytTest() as bytestrMy="0x"
Redim bytTest(7)
bytTest=rs.fields("TimeStamp").value 'Rs是你的Recordset,Timestamp是你的Timestamp字段。For i = 0 To 7
strMy = strMy + IIf(Len(CStr(Hex(byt(i)))) = 1, "0" + CStr(Hex(byt(i))), CStr(Hex(byt(i))))
Next這里得出來的值strMy就是TimeStamp字段的字串。然後就可以這樣寫SQL;SELECT * From YourTable WHERE TimeStamp=strMy
strMy = strMy + IIf(Len(CStr(Hex(byt(i)))) = 1, "0" + CStr(Hex(byt(i))), CStr(Hex(byt(i))))
應該為
strMy = strMy + IIf(Len(CStr(Hex(bytTest(i)))) = 1, "0" + CStr(Hex(bytTest(i))), CStr(Hex(bytTest(i))))