Counting records in a recordset

Originally posted by : Vojta (krikava@email.cz)How can I count records in a recordset?If it depends on used data provider,I use ADO.DB connection,provider Intersolv InterBase.

Originally posted by : enrico (piberg@casema.net)------------Vojta at 9/26/2001 5:34:35 AMHow can I count records in a recordset?If it depends on used data provider,I use ADO.DB connection,provider Intersolv InterBase.-------------------------------------hi,there's a few options, but the one I always use is very simple(I asume you use a loop to retrieve records).try the followingi hope this answeres your questionregards enrico

Originally posted by : Mike Hingley (mike.hingley@aquila-networks.co.uk)Try this - much more elegant...The recordset object exposes the count - it's really quite simple...Where RS = an ADODB.recordset objectrs.RecordCount (this relies on the fact that the provider, Cursor etc supports it)Mike Hingley - King of the 1 line fix------------enrico at 11/2/2001 10:12:06 AM------------Vojta at 9/26/2001 5:34:35 AMHow can I count records in a recordset?If it depends on used data provider,I use ADO.DB connection,provider Intersolv InterBase.-------------------------------------hi,there's a few options, but the one I always use is very simple(I asume you use a loop to retrieve records).try the followingi hope this answeres your questionregards enrico