function JoinString(Strlist:Tstrings;RepeatStr,Asplite:String):String; var i,len:integer; begin result:=''; if Strlist.count > 0 then begin len:=length(RepeatStr)+length(Asplite)+1; for i:=0 to Strlist.count-1 do Result:=Result+Asplite+copy(Strlist[i],len,maxint); Result:=RepeatStr+Asplite+Result; end; end;例子: JoinString(memo1.lines,12345,',');
JoinString(memo1.Lines,'12345',',');呵呵,漏了括号。。
sql server版块很多这样的问题,都已经解决n次了
select field2 form table1 where field1='12345' 将查询结果与field1字段组合输出就是了
text1.text:='12345,' select field2 form table1 where field1='12345' open; while not eof do beign Text1.text:=Text1.text+filedbyname('field2').asstring+','; next; end;
var
i,len:integer;
begin
result:='';
if Strlist.count > 0 then
begin
len:=length(RepeatStr)+length(Asplite)+1;
for i:=0 to Strlist.count-1 do
Result:=Result+Asplite+copy(Strlist[i],len,maxint); Result:=RepeatStr+Asplite+Result;
end; end;例子:
JoinString(memo1.lines,12345,',');
将查询结果与field1字段组合输出就是了
select field2 form table1 where field1='12345'
open;
while not eof do
beign
Text1.text:=Text1.text+filedbyname('field2').asstring+',';
next;
end;