舍近求远的:
qry->Close();
qry->SQL->Clear();
qry->SQL->Add("select isnull(count(*),0) as zs from aaa");
qry->Open();
int count = qry->FieldByName("zs")->AsInteger;//your value
方法很多,
简单的:
qry->Close();
qry->SQL->Clear();
qry->SQL->Add("select * zs from aaa");
qry->Open();
int count = qry->ReocrdCount;//your value
舍近求远的:
qry->Close();
qry->SQL->Clear();
qry->SQL->Add("select count(*) zs from aaa");
qry->Open();
int count = qry->FieldByName("zs")->AsInteger;//your value
qry->Close();
qry->SQL->Clear();
qry->SQL->Add("Declare @ret int");
qry->SQL->Add("select @ret = count(*) from aaa");
qry->SQL->Add("Select @ret Ret")
qry->Open();
int count = qry->FieldByName("Ret")->AsInteger;//your value