Results 1 to 8 of 8

Thread: [Resolved] Still executing last request

Threaded View

  1. #1

    Thread Starter
    Lively Member eusty's Avatar
    Join Date
    Jan 2006
    Location
    UK
    Posts
    71

    Resolved [Resolved] Still executing last request

    I get the error when running the code below, both from the IDE and from the compiled exe. Running using the IDE and putting a breakpoint and then stepping it works fine.

    So what's it waiting for? I've put 1 second delays all over the place to see what is causing the error...but still get the error


    17/01/2006 01:14:45",35764,"Still executing last request","Dailytext_01 Function CheckIfFileExist

    VB Code:
    1. Public Function CheckIfFileExist(strRemoteFolder As String, strRemoteFile As String) As Boolean
    2. Dim var_data As Variant
    3. Dim str_data As String
    4. Dim i%, strFtpFiles() As String
    5. Dim blnExist As Boolean
    6.  
    7.  
    8. On Error GoTo ErrorLog
    9.  
    10.     Screen.MousePointer = vbHourglass
    11.  
    12. With Inet1
    13.         .Execute , strRemoteFolder
    14.         sngWait = SleepEx(1000, 1000)
    15.         .Execute , "DIR"
    16.         sngWait = SleepEx(1000, 1000)
    17.        
    18.             var_data = .GetChunk(9, icString)
    19.             str_data = str_data & var_data
    20.            
    21.        
    22.         sngWait = SleepEx(1000, 1000)
    23.         str_data = Trim(str_data)
    24.        
    25.                
    26.             If str_data <> "<!DOCTYPE" Then
    27.                 blnExist = True
    28.                 'Exit For
    29.             End If
    30.        
    31.        
    32.         'use the following line only if you have to close connection
    33.         '''.Execute , "CLOSE"
    34.     End With
    35.    
    36.    sngWait = SleepEx(1000, 1000)
    37.     DeleteUrlCacheEntry (Inet1.url & strRemoteFolder & "/" & strRemoteFile)
    38.     sngWait = SleepEx(1000, 1000)
    39.     CheckIfFileExist = blnExist
    40.    
    41.     Screen.MousePointer = vbDefault
    42.    
    43.     Exit Function

    Any ideas...this is driving me mad!!
    Last edited by eusty; Jan 19th, 2006 at 07:50 PM.
    Steve

    No trees were cut down or harmed in the posting of this message. A lot of electrons were, however, severely inconvenienced.

Posting Permissions

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



Click Here to Expand Forum to Full Width