[dba-SQLServer]ADO FInd and SQL Server

Mwp.Reid at Queens-Belfast.AC.UK Mwp.Reid at Queens-Belfast.AC.UK
Mon Aug 25 11:30:15 CDT 2003


We need to pass multipe values to FInd or Filter in ADO.

Any ideas?

  rstBuilding.Open ("select * from tblBuilding"), cnn, adOpenKeyset, 
adLockPessimistic

        rstBuilding.Filter "fldClusterID = " & Val(Nz(txtClusterID)) & " AND 
fldBuildingNumber = '" _
            & Nz(txtBuildingNumber) & "'"


Martin


More information about the dba-SQLServer mailing list