请问怎么知道boolean字段“状态”的所有为False的总数？(43分)

N

netmax

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-06

• #1

要知道boolean字段“状态”的所有为False的总数，我用了
Select Count(状态) as tmp from ylwb Where 状态=True
再procedure TForm1.Button1Click(Sender: TObject);
var
tmp:integer;
begin
Form1.Query1.Open;
showmessage(inttostr(tmp));
end;
怎么不对呢？

 

M

ml.guo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-06

• #2

Select Count(状态) as tmp from ylwb Where 状态=False
再procedure TForm1.Button1Click(Sender: TObject);
var
tmp:integer;
begin
Form1.Query1.Open;
showmessage(inttostr(Query1.FieldByName('tmp').AsString);
end;

 

N

netmax

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-06

• #3

如果我的“tmp”仅是一个变量呢？

 

N

netmax

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-06

• #4

接受答案了.