VB+SQL 6.5 WHY? rs.recordcount=-1
dim connect as new adodb.connect
dim rs as new adodb.recordset
connect.open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=xbdatabase;Data Source=192.168.0.111"
rs.open"select * from salsedetail where salesNo='A2000-001'",connect,adOpenKeyset, adLockOptimistic
if rs.recordcount>0 then
...
end if
請問:為什麼rs.recordcount=-1,並且rs("salesno")='A2000-001',rs("rmid")="FB001"