procedure TForm1.Button4Click(Sender: TObject); var i : integer; Str : String; begin Str := ''; for i := 0 to ListBox1.Items.Count - 1 do begin if Str = '' then Str := QuotedStr(ListBox1.Items.Strings[i]) else Str := Str + ',' + QuotedStr(ListBox1.Items.Strings[i]); end; ShowMessage(Str); end;
谢谢这位 我自己也写了一个 procedure TForm1.Button4Click(Sender: TObject); var i : integer; Str : String; begin sql := sql + 'haa05c in ('''; for i := 0 to suiListBox2.Count-1 do begin sql := sql +suiListBox2.Items[i]+''','''; end; sql := copy(sql,1,length(sql)-2); sql := sql + ') and '; showmessage(sql); end; 结贴给分
var
i : integer;
Str : String;
begin
Str := '';
for i := 0 to ListBox1.Items.Count - 1 do
begin
if Str = '' then
Str := QuotedStr(ListBox1.Items.Strings[i])
else Str := Str + ',' + QuotedStr(ListBox1.Items.Strings[i]);
end; ShowMessage(Str);
end;
我自己也写了一个
procedure TForm1.Button4Click(Sender: TObject);
var
i : integer;
Str : String;
begin
sql := sql + 'haa05c in (''';
for i := 0 to suiListBox2.Count-1 do
begin
sql := sql +suiListBox2.Items[i]+''',''';
end;
sql := copy(sql,1,length(sql)-2);
sql := sql + ') and ';
showmessage(sql);
end;
结贴给分