我的设计意图是:如果执行后,没有相应的记录就开始下一步骤SQL1 = " SELECT StInf.StNO, StInf.Lon, StInf.Lat, StInf.Lev"
SQL1 = SQL1 & " From StInf WHERE StInf.StNO = " & s1.STNO1
SQL1 = SQL1 & " ORDER BY StInf.StNO "db.execute sqlif 数据库没有相应的记录 then
………………
end if
SQL1 = SQL1 & " From StInf WHERE StInf.StNO = " & s1.STNO1
SQL1 = SQL1 & " ORDER BY StInf.StNO "db.execute sqlif 数据库没有相应的记录 then
………………
end if
MsgBox "沒有記錄"
Else
msgbox rs.RecordCount
End If
dim RS as adodb.recordset
strA=""PROVIDER=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source="
set rs=new adodb.recordset
SQL1 = " SELECT StInf.StNO, StInf.Lon, StInf.Lat, StInf.Lev"
SQL1 = SQL1 & " From StInf WHERE StInf.StNO = " & s1.STNO1
SQL1 = SQL1 & " ORDER BY StInf.StNO "
rs.open sql1,stra, adOpenStatic, adLockReadOnlyif rs.RecordCount =0 then '数据库没有相应的记录
………………
end if