How to move to count record

[nor]

Hello...
I've problem to count records in my table. I've try this

dim recount
objrec.movelast
recount=objrec.recordcount
objrec.movefirst

but error returns:

Microsoft OLE DB Provider for ODBC Drivers error '80040e24'
The rowset does not support fetching backwards
/hr/dbs/news.asp, line 25

[Kris Eiben]

Like it says, the type of recordset you've opened doesn't support fetching
backwards. The default type is read-only, forward-only (or something like
that). If you want to count records, it's probably more efficient to open 1
rs that just returns count(insertTheNameOfYourIDField), then another
recordset to get the records. Or open as a cursor type that supports
rs.recordcount. See the FAQ for more info on this. www.aspfaq.com

nor wrote in message <39f64ae3$1@news.devx.com>...
>
>Hello...
>I've problem to count records in my table. I've try this
>
>dim recount
>objrec.movelast
>recount=objrec.recordcount
>objrec.movefirst
>
>but error returns:
>
>Microsoft OLE DB Provider for ODBC Drivers error '80040e24'
>The rowset does not support fetching backwards
>/hr/dbs/news.asp, line 25
>

[Frixos Kimonis]

Hello,

You could use 'GetRows' i.e

Dim strTable
Dim numcols
Dim numrows

strTable=objRS.GetRows

numcols=ubound(strTable,1)
'Number of records retrieved
numrows=ubound(strTable,2) + 1

Frixos

"nor" <aida_nor@hotmail.com> wrote in message
news:39f64ae3$1@news.devx.com...
>
> Hello...
> I've problem to count records in my table. I've try this
>
> dim recount
> objrec.movelast
> recount=objrec.recordcount
> objrec.movefirst
>
> but error returns:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e24'
> The rowset does not support fetching backwards
> /hr/dbs/news.asp, line 25
>