var AI:array [1..30] of string; j,i:integer; SText:string; begin SText:='select ' for i:=1 to 30 do AI:='A'+intostr(i); ADOTableB.open; ADOTableB.first; for i:=1 to 30 do begin SText:=SText+AI[i]+' as '+ADOTableB.FieldByname('Item').Asstring; end SText:=' from A' ADOQueryA.close; ADOQueryA.sql.clear; ADOQueryA.AQL.ADD(SText); ADOQueryA.open end;
月份 年龄 性别
A1
A2
A3
AI:array [1..30] of string;
j,i:integer;
SText:string;
begin
SText:='select '
for i:=1 to 30 do
AI:='A'+intostr(i);
ADOTableB.open;
ADOTableB.first;
for i:=1 to 30 do
begin
SText:=SText+AI[i]+' as '+ADOTableB.FieldByname('Item').Asstring;
end
SText:=' from A'
ADOQueryA.close;
ADOQueryA.sql.clear;
ADOQueryA.AQL.ADD(SText);
ADOQueryA.open
end;
如果是用的FIREBIRD数据库,还可以在存储过程中实现