procedure TForm19.Button1Click(Sender: TObject);
var
i:integer;
str1,str2,str3,sqlstr:string;
begin
str2:='';
for i:=0 to GroupBox1.ControlCount-1 do
begin
if GroupBox1.Controls[i] is TCheckBox then
begin
if TCheckBox(GroupBox1.Controls[i]).Checked then
begin
str1:=str1+TCheckBox(GroupBox1.Controls[i]).Caption;
end;
end;
if str1<>'' then
begin
str2:=str2+'(select '+str1+' from 书籍信息维护 group by '+str1+' having count('+str1+')>1)union';
str1:='';
end;
end;
str3:=copy(str2,1,length(str2)-5);
for i:=0 to GroupBox1.ControlCount-1 do
begin
if GroupBox1.Controls[i] is TCheckBox then
begin
if TCheckBox(GroupBox1.Controls[i]).Checked then
begin
str1:=str1+TCheckBox(GroupBox1.Controls[i]).Caption;
end;
end;
if str1<>'' then
begin
break;
end;
end; close;
form10.adoquery1.SQL.Clear;
sqlstr:='select * from 书籍信息维护 where '+str1+' in ('+str3+')';
form10.adoquery1.SQL.Add(sqlstr);
form10.adoquery1.Open;
end;从这个表中选择属性的。忘大神给指导指导!
var
i:integer;
str1,str2,str3,sqlstr:string;
begin
str2:='';
for i:=0 to GroupBox1.ControlCount-1 do
begin
if GroupBox1.Controls[i] is TCheckBox then
begin
if TCheckBox(GroupBox1.Controls[i]).Checked then
begin
str1:=str1+TCheckBox(GroupBox1.Controls[i]).Caption;
end;
end;
if str1<>'' then
begin
str2:=str2+'(select '+str1+' from 书籍信息维护 group by '+str1+' having count('+str1+')>1)union';
str1:='';
end;
end;
str3:=copy(str2,1,length(str2)-5);
for i:=0 to GroupBox1.ControlCount-1 do
begin
if GroupBox1.Controls[i] is TCheckBox then
begin
if TCheckBox(GroupBox1.Controls[i]).Checked then
begin
str1:=str1+TCheckBox(GroupBox1.Controls[i]).Caption;
end;
end;
if str1<>'' then
begin
break;
end;
end; close;
form10.adoquery1.SQL.Clear;
sqlstr:='select * from 书籍信息维护 where '+str1+' in ('+str3+')';
form10.adoquery1.SQL.Add(sqlstr);
form10.adoquery1.Open;
end;从这个表中选择属性的。忘大神给指导指导!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货