nz函数在ado中如何使用？

cnwang

Dim cnn1 As ADODB.Connection
    Dim rst1 As ADODB.Recordset
    Dim strCnn As String

    strCnn = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=e:\data;Exclusive=No;"
    Set cnn1 = New ADODB.Connection
    cnn1.Open strCnn
     
    Set rst1 = New ADODB.Recordset
    rst1.CursorType = adOpenKeyset
    rst1.LockType = adLockOptimistic
    sql = "select fld1 ,nz(fld2) from tbl;"
    rst1.Open sql, cnn1

运行到最后一句，提示
ODBC驱动程序不支持所需的属性。　WHY？

lou

将'sql = "select fld1 ,nz(fld2) from tbl;"'改为:'sql = "select fld1 ," & nz(fld2,0) & "from tbl"试试看！

zhuyiwen

nz为ACCESS的函数,不能用在这些地方