Object doesn't support this property or method: ZoneRS.MoveFirst'

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • shank
    #1

    Object doesn't support this property or method: ZoneRS.MoveFirst'

    Can anyone give me some general ideas on why an error like

    Object doesn't support this property or method: 'ZoneRS.MoveFir st'

    comes up on a page?
    MoveFirst is a command to move to the first record... correct?
    thanks


    Tags: None
    • Dan Brussee
      #2
      Re: Object doesn't support this property or method: ZoneRS.MoveFirs t'

      On Thu, 30 Oct 2003 19:25:59 -0500, "shank" <shank@tampabay .rr.com>
      wrote:
      [color=blue]
      >Can anyone give me some general ideas on why an error like
      >
      >Object doesn't support this property or method: 'ZoneRS.MoveFir st'
      >
      >comes up on a page?
      >MoveFirst is a command to move to the first record... correct?
      >thanks
      >[/color]

      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.

        Comment

        • Chris Barber
          #3
          Re: Object doesn't support this property or method: ZoneRS.MoveFirs t'

          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:lrc3qvs3ft 0gq1b7fbssnjiad lf3ca97g3@4ax.c om...
          On Thu, 30 Oct 2003 19:25:59 -0500, "shank" <shank@tampabay .rr.com>
          wrote:
          [color=blue]
          >Can anyone give me some general ideas on why an error like
          >
          >Object doesn't support this property or method: 'ZoneRS.MoveFir st'
          >
          >comes up on a page?
          >MoveFirst is a command to move to the first record... correct?
          >thanks
          >[/color]

          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.


            Comment

            • Dan Brussee
              #4
              Re: Object doesn't support this property or method: ZoneRS.MoveFirs t'

              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.NOS PAM> wrote:
              [color=blue]
              >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:lrc3qvs3f t0gq1b7fbssnjia dlf3ca97g3@4ax. com...
              >On Thu, 30 Oct 2003 19:25:59 -0500, "shank" <shank@tampabay .rr.com>
              >wrote:
              >[color=green]
              >>Can anyone give me some general ideas on why an error like
              >>
              >>Object doesn't support this property or method: 'ZoneRS.MoveFir st'
              >>
              >>comes up on a page?
              >>MoveFirst is a command to move to the first record... correct?
              >>thanks
              >>[/color]
              >
              >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.
              >[/color]

                Comment

                • shank
                  #5
                  Re: Object doesn't support this property or method: ZoneRS.MoveFirs t'

                  Thanks to all..!
                  I took your suggestions and picked the page apart..
                  Ended up scrapping it and rebuilding. It now works.
                  I hate not know what I did wrong...
                  sigh...


                    Comment

                    • Chris Barber
                      #6
                      Re: Object doesn't support this property or method: ZoneRS.MoveFirs t'

                      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:eii3qv4m51 deuoirep41283b5 hcj03dmr0@4ax.c om...
                      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.NOS PAM> wrote:
                      [color=blue]
                      >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:lrc3qvs3f t0gq1b7fbssnjia dlf3ca97g3@4ax. com...
                      >On Thu, 30 Oct 2003 19:25:59 -0500, "shank" <shank@tampabay .rr.com>
                      >wrote:
                      >[color=green]
                      >>Can anyone give me some general ideas on why an error like
                      >>
                      >>Object doesn't support this property or method: 'ZoneRS.MoveFir st'
                      >>
                      >>comes up on a page?
                      >>MoveFirst is a command to move to the first record... correct?
                      >>thanks
                      >>[/color]
                      >
                      >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.
                      >[/color]


                        Comment

                        Previous template Next
                        Working...