帮忙看以下这条语句是检测表中是否有重复记录还是没有重复记录?
dim str as string
str="select * from T_information where F_id='" & text1.text &"'"
if cn.execute(str).eof then
记录重复还是不重复?
end if
dim str as string
str="select * from T_information where F_id='" & text1.text &"'"
if cn.execute(str).eof then
记录重复还是不重复?
end if
if rst!CountOfRecords > 1 then
msgbox "有重复的记录"
elseif rst!CountOfRecords = 1 then
msgbox "有一条记录"
elseif rst!CountOfRecords = 0 then
msgbox "没有记录"
end if