Solved

Adventures with "OleControl Shell.Explorer.2" deleting the temporary files issue.

Posted on 2012-12-28
5
941 Views
Last Modified: 2013-01-02
ok, got my OleControl Shell.Explorer.2 activex control to work and it shows pdfs and graphics files.  But of course it needs a pdf file to exist so I create one.  I am storing the documents in my mssql database as a varchar(max)

So, when my user wants to view the document, I create a temporary file and ole.navigate2 to the file.  

But when I close the form, I want to delete the temporary file but of course it is in use.

So I navigate2 to "About:Blank" but I still have to wait .3 of a second before it is released.

inkey(.3)
delete file (tempfilename)

Open in new window


Tried a DOEVENTS but no difference.  I also have this after I navigate to the blank page:

DO WHILE (this.Olecontrol1.Busy OR this.Olecontrol1.ReadyState <> 4) 
   DOEVENTS
ENDDO

Open in new window


but again, still need the delay.  So any ideas, not sure if the inkey(.3) is going to be enough for all my client's slow machines and it seems like a patch and not a solution.
0
Comment
Question by:peterhupp
  • 3
  • 2
5 Comments
 
LVL 41

Assisted Solution

by:pcelba
pcelba earned 500 total points
ID: 38728412
Yes, the control (or OS) releases the file for deletion after certain delay obviously. I am also navigating to a blank page and waiting for ready state and that's not sufficient in some cases...

So I am attempting to delete the temp file in a loop for 2 seconds:
ldDate = DATE()
lnTime = SECONDS()
llSuccess = .F.
DO WHILE !m.llSuccess AND SECONDS() < m.lnTime + 2 AND DATE() = m.ldDate
TRY
  DELETE FILE ...
  llSuccess = .T.
CATCH
ENDTRY
DOEVENTS FORCE
ENDDO

The advantage of this solution is no delay when the deletion attempt succeeds.
But it still does not ensure the file deletion sometimes. In such case the file waits for temp folder general cleanup which deletes all files older than 1 week from the temp folder when the app exits.
0
 
LVL 3

Accepted Solution

by:
peterhupp earned 0 total points
ID: 38728426
Actually I figured this one out and I think it is the best solution.  By using the open I do not attempt the deletion till it either times out or I am able to get RW access.

   lnAttempts= 0
   lnHandle = -1
   DO WHILE lnHandle=-1 and lnAttempts<51 
      lnAttempts = lnAttempts + 1 
      lnHandle = fopen(this.tmpFileName,12)  
      INKEY(.1)
   enddo
   FCLOSE(lnHandle)
   * if timeout handle that otherwise
   DELETE file (this.tmpFileName)

Open in new window


This is a subset of my code but it shows the logic of the fopen to test the release of the file.
0
 
LVL 41

Expert Comment

by:pcelba
ID: 38728441
Yes, your solution must work because the delay could be more than 5 seconds which is enough even for slow systems.
0
 
LVL 3

Author Comment

by:peterhupp
ID: 38728454
I did try the try..delete file.... catch but sometimes it would make VFP crash.
0
 
LVL 3

Author Closing Comment

by:peterhupp
ID: 38736052
My solution worked the best and 100% of the time.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Trouble Pulling from a FoxPro ODBC Connection to SQL 6 509
Foxpro executable does not show up 3 454
FoxPro in WIndows 10 23 5,429
FoxPro .frx file - Embed an image 3 131
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question