• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

.Absolute Page = -1

SQL 2k : VB6 :

I m using Stored Procedure to Retrieve the query Result

Results :

RecordSet.AbsolutePage = -1
"With cmd
            .ActiveConnection = Con
            .CommandType = adCmdStoredProc
            .CommandText = "Ledger"
            .Parameters.Append cmd.CreateParameter("@AccountNo", adInteger, adParamInput, , AccountNo)
            .Parameters.Append cmd.CreateParameter("@FromDate", adDate, adParamInput, , FromDate)
            .Parameters.Append cmd.CreateParameter("@ToDate", adDate, adParamInput, ,ToDate)
            .Parameters.Append cmd.CreateParameter("@Ledger_Type", adInteger, adParamInput, , LEDGER_TYPE)
            .Parameters.Append cmd.CreateParameter("@Criteria", adVarChar, adParamInput, 100, "")
            .Parameters.Append cmd.CreateParameter("@UserID", adInteger, adParamInput, , User.UserId)
            If Err.Number = 0 Then
            End If
            Set ARS= Nothing
            ARS.CursorLocation = adUseClient
            Set ARS= cmd.Execute
        End With

Open in new window

  • 2
  • 2
1 Solution
George HirstCommented:
The Recordset is empty, the current position is unknown,  or not supported by the provider
Anthony PerkinsCommented:
As andycrofts has indicated the recordset is a firehose (forward-only, read-only) cursor and does not support that property.  But don't take my word for it, you can confirm this yourself, just do:

MsgBox "Supports AbsolutePage: " & CBool(ARS.Supports(adApproxPosition))
Harsh08Author Commented:

Supports AbsolutePage: False.

What do you suggest?

Anthony PerkinsCommented:
It depends.  If performance is not paramount and you have to use AbsolutePage then consider using the Recordset Open method instead of the Command Execute method.  That will allow you to set the Cursor Type that supports AbsolutePage.
Harsh08Author Commented:
Thanks. I had to change the code to Recordset Open Method.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now