'where xxxxx like '+''''+'%'+xxxxx+'%'+''''
解决方案 »
- 如何读取SQL文件
- GB13000字库区位读取、汉字显示
- 求:delphi 中 “迭代算法”的列子——————在先等待!!!!
- Tcomm问题
- 如何在视频中叠加入其它图像..
- 菜单小问题!!!在线等待!!!
- 大爷,如果Hook删除某个文件或重命名文件。
- 请教诸位关于内存泄露的问题
- 请问:Code Completion关闭了,怎样打开啊?
- 急问:怎样把类似如下的一个字符串:永久;长期;短期,转换为一个在ComboBox控件下显示的下拉列表?
- 一个关于自动入坞的问题:在可入坞对象已入坞时关闭可入坞对象,此时我希望修改船坞对象的一些属性???
- 请教:TreeView 的节点能否拖放到另一个节点,象资源管理器一样。怎么实现?
MainForm.ADOman.Close; if age='30以下' then begin
mainForm.Adoman.CommandText:='Select * from manAger where manager_name like ''%'+ Username +'%'' and Manager_Sex like ''%'+ sex +'%'' and manager_status like ''%'+ shenfen +'%'' and manager_country like ''%'+ outcountry +'%'' and manager_culture like ''%'+ wenhua +'%'' and manager_office like ''%'+ office +'%'' and manager_age <= 30';
end else if age='30-50Ëê' then begin
mainForm.Adoman.CommandText:='Select * from manAger where manager_name like ''%'+ Username +'%'' and Manager_Sex like ''%'+ sex +'%'' and manager_status like ''%'+ shenfen +'%'' and manager_country like ''%'+ outcountry +'%'' and manager_culture like ''%'+ wenhua +'%'' and manager_office like ''%'+ office +'%'' and manager_age > 30 and manager_age < 50';
end else if age='50ËêÒÔÉÏ' then begin
mainForm.Adoman.CommandText:='Select * from manAger where manager_name like ''%'+ Username +'%'' and Manager_Sex like ''%'+ sex +'%'' and manager_status like ''%'+ shenfen +'%'' and manager_country like ''%'+ outcountry +'%'' and manager_culture like ''%'+ wenhua +'%'' and manager_office like ''%'+ office +'%'' and manager_age >= 50 ';
end else begin
mainForm.Adoman.CommandText:='Select * from manAger where manager_name like ''%'+ Username +'%'' and Manager_Sex like ''%'+ sex +'%'' and manager_status like ''%'+ shenfen +'%'' and manager_country like ''%'+ outcountry +'%'' and manager_culture like ''%'+ wenhua +'%'' and manager_office like ''%'+ office +'%'' ';
end;
MainForm.AdoMan.Open;
MainForm.TabMan.show;
end
else if RBFamily.Checked=True Then Begin MainForm.AdoFam.Close;
if age='30ËêÒÔÏÂ' then begin
MainForm.AdoFam.CommandText:='select * from Family where family_name like ''%'+ username +'%'' and family_sex like ''%'+ sex +'%'' and family_status like ''%'+ shenfen+'%'' and family_office like ''%'+ office +'%'' and family_age<30 ';
end else if age='30-50Ëê' then begin
MainForm.AdoFam.CommandText:='select * from Family where family_name like ''%'+ username +'%'' and family_sex like ''%'+ sex +'%'' and family_status like ''%'+ shenfen+'%'' and family_office like ''%'+ office +'%'' and family_age < 50 and family_age > 30 ';
end else if age='50ËêÒÔÉÏ' then begin
MainForm.AdoFam.CommandText:='select * from Family where family_name like ''%'+ username +'%'' and family_sex like ''%'+ sex +'%'' and family_status like ''%'+ shenfen+'%'' and family_office like ''%'+ office +'%'' and family_age > 50 ';
end else begin
MainForm.AdoFam.CommandText:='select * from Family where family_name like ''%'+ username +'%'' and family_sex like ''%'+ sex +'%'' and family_status like ''%'+ shenfen+'%'' and family_office like ''%'+ Office +'%'' ';
end ;
MainForm.Adofam.Open;
MainForm.Tabfam.show; end
问题就出在office上,如果familm_office为空的话就搜索不到,不管office作不作为搜索条件,但是在manager_office中就可以,都是变量office,我实在不明白了,高手救救我吧,,,