if Adoquery.Locate('fieldName','张三',[locaseInsensitive]) then showmessage('可以找到') else showmessage('找不到');
要查“张三”的记录,但数据库里没有:adoquery1.sql.clear; adoquery1.sql.add('select * from tablename where fieldname=''张三''') adoquery1.close; adoquery1.open;if adoquery1.eof=false then showmessage('没有张三的记录') else showmessage('找到张三的记录,一共'+inttostr(adoquery1.recordcount)+'条');
对不起,反了:if adoquery1.eof=false then showmessage('找到张三的记录,一共'+inttostr(adoquery1.recordcount)+'条') else showmessage('没有张三的记录');
对上面的仁兄我建议啊,在IF这一段改一下, if adoquery1.recordcount=0 then showmessage(没有张三的记录') else showmessage('找到张三的记录,一共'+inttostr(adoquery1.recordcount)+'条');
showmessage('可以找到')
else showmessage('找不到');
adoquery1.sql.add('select * from tablename where fieldname=''张三''')
adoquery1.close;
adoquery1.open;if adoquery1.eof=false then
showmessage('没有张三的记录')
else
showmessage('找到张三的记录,一共'+inttostr(adoquery1.recordcount)+'条');
showmessage('找到张三的记录,一共'+inttostr(adoquery1.recordcount)+'条')
else
showmessage('没有张三的记录');
if adoquery1.recordcount=0 then
showmessage(没有张三的记录')
else
showmessage('找到张三的记录,一共'+inttostr(adoquery1.recordcount)+'条');