Question

delphi 将SQL的查询结果取出来

vsql := ' select count(*) from lmjzllfx where year(ghsj)='+vstr+'and month(ghsj)='+sm+''; 要将上面语句的查询结果取出来，语句我给忘了，谁知到麻烦告诉一下=。=
int sl=cmd.Execute(vsql);这个是在C#中的写法，delphi要怎么写？ 用ADO连接数据库

Answer 1

var
Countstr :string;
vsql:='select count(*) as allCount from imjzllfx where year(ghsj)='+vstr+' and moth(ghs)='+sm+';
.....
下面这句就是你想要的:
countStr:=adoquery.fieldbyname('allCount').asstring;

Answer 2

现在假设你是用adoquery控件连接数据库
adoquery.fields[0].asInteger;