用Select Count(*) as ... 来取记录数!
-------------------
要用RecordCount就像1213兄说的,先Last一下!
----------------------
下面是Delphi的帮助,我也是抄来的!
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的确有问题!)