There is a cursor type and a cursor location that can be specified when you
open the recordset. A 'firehose' (forward-only, server-side cursor) is the
fastest type of recordset to request and traverse and is thus the default.
http://www.adopenstatic.com/faq/jetcursortypes.asp
I don't know how the MoveFirst restriction is implemented - I would presume
an error is raised.
Hope this helps.
Chris.
"Dan Brussee" <db******@nc.rr.com> wrote in message
news:ei********************************@4ax.com...
I hontestly have not tested the thought, but I figured if the user had
an real recordset, it would "have" the MoveFirst method even if it
generated an error when it was used. In other words, the MoveFirst
method is defined, but not allowed for Forwared Only recordsets. Does
this make sense?
On Fri, 31 Oct 2003 02:02:54 -0000, "Chris Barber"
<ch***@blue-canoe.co.uk.NOSPAM> wrote:
It may be a forward-only 'firehose' cursor (default if no other cursor and
cursor location specified) in which case that error is correct - moving
backward through the recordset wouldn't be supported.
Chris.
"Dan Brussee" <db******@nc.rr.com> wrote in message
news:lr********************************@4ax.com.. .
On Thu, 30 Oct 2003 19:25:59 -0500, "shank" <sh***@tampabay.rr.com>
wrote:
Can anyone give me some general ideas on why an error like
Object doesn't support this property or method: 'ZoneRS.MoveFirst'
comes up on a page?
MoveFirst is a command to move to the first record... correct?
thanks
For a recordset object, it is. Post the connection code and the code
you use to set the ZoneRS recordset. If the recordset is not
instantiated (failed SQL statement???) the Recordset object is not
there, so what you have is a variant - and variants do not have
MoveFirst methods.