adAsyncExecute


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: adAsyncExecute

  1. #1
    Join Date
    Mar 2005
    Posts
    37

    adAsyncExecute

    In wich case i need to use this param in ADO connection with access and vb6 classic?
    Tks.

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    http://support.microsoft.com/kb/190988

    The example given is for reference only. It uses SQL Server as a back end which is when you would probably use adAsyncExecute - I can't image why you would ever use it with Access.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Oct 2008
    Posts
    142

    asynchronous execution

    hi there,

    according to this page --> http://www.bigresource.com/VB-adAsyn...rJ2CAqDTi.html it rocks!

    the point of this loop:

    Code:
    ' Poll the command status
    While (Comm.State And (adStateConnecting Or adStateExecuting Or adStateFetching)) <> 0
    DoEvents
    Wend
    is that doevents will update your windows form while this db command is executing, like a classical progress bar display.

    so what is he missing?
    his cpu goes to a 100%.
    it surely does... because of this loop.
    so, a good guess for a fix would be (maybe):

    Code:
    ' Poll the command status
    While (Comm.State And (adStateConnecting Or adStateExecuting Or adStateFetching)) <> 0
    DoEvents
    Sleep(1000) 'it will sleep for a second with each loop iteration, thus cpu will not be pegged
    Wend
    that's it,

    tonci korsano

Similar Threads

  1. adAsyncFetch
    By Nick in forum VB Classic
    Replies: 6
    Last Post: 03-30-2000, 03:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center