if radiobutton1.Checked then
if edit1.Text='' then
begin
showmessage('请输入姓名');
end
else
if not adotable1.Locate('username',edit1.Text,[]) then
begin
showmessage('用户不存在');
edit1.Text:='';
end
else
adotable1.Filtered:=false;
adotable1.Filter:='username like'+''''+'%'+trim(edit1.text)+'%'+'''';
adotable1.Filtered:=true;
调试程序的时候,查询就报错, adotable1.Filter:='username like'+''''+'%'+trim(edit1.text)+'%'+'''';
adotable1.Filtered:=true;请大家帮忙指导一下,谢谢
if edit1.Text='' then
begin
showmessage('请输入姓名');
end
else
if not adotable1.Locate('username',edit1.Text,[]) then
begin
showmessage('用户不存在');
edit1.Text:='';
end
else
adotable1.Filtered:=false;
adotable1.Filter:='username like'+''''+'%'+trim(edit1.text)+'%'+'''';
adotable1.Filtered:=true;
调试程序的时候,查询就报错, adotable1.Filter:='username like'+''''+'%'+trim(edit1.text)+'%'+'''';
adotable1.Filtered:=true;请大家帮忙指导一下,谢谢
试试修改username字段名称或者将username修改成[username]。
codeadotable1.Filter:='[username] like '+''''+'%'+trim(edit1.text)+'%'+'''';的語法才是正確的.