RE: RecordCount

2002-07-01 Thread Venu
> - Original Message - > From: "Steve Edberg" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, June 28, 2002 1:49 PM > Subject: RE: RecordCount > > > > I assume you are using ODBC to access

Re: RecordCount

2002-06-24 Thread Francisco Reinaldo
Some database providers implementation always return -1 no matter the amount of records is returned. That happens to ADO too for certain cursors. The best way to go to count records is Count(*), prepare a query like Select count(MyField) from MyTable Where ... and then get the value. I hope it he