> > ya cna't do it, AFAIK. ADO doesn't like returning record
> > counts. If you need
> > to know that badly, use select count(*) first.
>
> *sigh* I had suspected as much. Is that ADO in general, or just the
> particular DB backend?
I think whether RecordCount is valid is a result of the type of cursor
type you specify when you open the RecordSet.
>From MSDN:
The cursor type of the Recordset object affects whether the number of
records can be determined. The RecordCount property will return -1 for a
forward-only cursor; the actual count for a static or keyset cursor; and
either -1 or the actual count for a dynamic cursor, depending on the
data source.
Do you have the option to specify a cursor type when opening the
recordset?
Paul Ritchie
RCS (NZ) Ltd.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
