Chris
Fri Oct 31 03:56:01 CST 2003
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" <dbrussee@nc.rr.com> wrote in message
news:eii3qv4m51deuoirep41283b5hcj03dmr0@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"
<chris@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" <dbrussee@nc.rr.com> wrote in message
>news:lrc3qvs3ft0gq1b7fbssnjiadlf3ca97g3@4ax.com...
>On Thu, 30 Oct 2003 19:25:59 -0500, "shank" <shank@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.
>