为何返回记录数是-1

[zmcpu]

QUERY 查询出结果集已经显示出来，但为什么recordcount为-1?
源码如下：
with datafrm.Query2 do
begin
close;
sql.clear;
sql.Add('Select CustomerId,CustomerName,Address,Postcode,Touchman,');
sql.Add('phone,Fax,SuperiorName,BankName,AccountID,TaxID,NetAddress,Email,CustomerRemarks,TouchmanRemarks');
sql.Add (' From CustomerTable ');
sql.Add('order by customerid');
prepare;
open;
k:=recordcount;
end;
StaticText1.Caption :='符合条件的客户数量为：'+inttostr(k );

[tygh2000]

我用ado没有这种情况的，你在open后面加一个.last，再看看呢？

[macro_love]

Note: Use RecordCount with care, because record counting can be a costly operation, especially for SQL queries that return large result sets. Generally, an application should only use RecordCount with Paradox and dBASE tables.
你看帮助呀，recordCount只能用在哪些表中,你的表又是什么类型

[newwen]

BDE是这样的