Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    2

    Question Unanswered: SQL Select statement progress in progress bar?

    I want to view the progress of a SQL select statement (made from VB) in a progress bar.

    How can I do this?

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Quote Originally Posted by peet1909
    I want to view the progress of a SQL select statement (made from VB) in a progress bar.

    How can I do this?
    First, issue the select statement as a SELECT COUNT() statement, to return the number of records which will match the actual select statement. Use this value in determining the percentage completion, later.

    Next, you will have to open the recordset asynchronously.

    Do an MSDN or Google search for ADO Asynchronous Recordset

    Essentially, when using asynchronous recordsets, ado can return the number of records returned in an asynchronous event.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •