比较通用的是 adoQuery的sql语句为select * from mytab where 1>2 然后,打开ADOQuery i:= AdoQuery.FieldCount;就可以取出字段个数
如果是sql server select count(*) as cou from syscolumns where id in (select id from sysobjects where name = 待查表名)
另一帖月亮已经回复如下var i: integer; beginwith query do begin close; sql.clear; sql.add('select sum(colname) as sumcol from tablename'); open; i:= fieldbyanem('sumcol').asinteger; end; end;
adoQuery的sql语句为select * from mytab where 1>2
然后,打开ADOQuery
i:= AdoQuery.FieldCount;就可以取出字段个数
select count(*) as cou from syscolumns where id in (select id from sysobjects where name = 待查表名)
i: integer;
beginwith query do
begin
close;
sql.clear;
sql.add('select sum(colname) as sumcol from tablename');
open;
i:= fieldbyanem('sumcol').asinteger;
end;
end;