|
經(jīng)測試,在 JET 4.0 (Access 2000 及以后版本中) 支持 BAND (Binary AND) / BOR (Binary OR) / BXOR (Binary XOR) / BNOT (Binary NOT) 操作。但 不 能用于 ACCESS 查詢。可以通過 ADO 語句調(diào)用。
例:- Function TestBand()
- Dim rs As New ADODB.Recordset
- Dim strSql As String
- strSql = "SELECT c2, (c2 BAND 2) As MyResult FROM cc;"
- rs.Open strSql, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
- Do While Not rs.EOF
- Debug.Print rs!c2, rs!MyResult
- rs.MoveNext
- Loop
- rs.Close
- Set rs = Nothing
- End Function
復制代碼 運行結果:
1 0
2 2
3 2
4 0
5 0
6 2
7 2
8 0
9 0
可是, 未找到任何正式的文檔說明.
2004.08.10 |
|