What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.
Course Of The Month
7 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Adventures with "OleControl Shell.Explorer.2" deleting the temporary files issue.
Posted on 2012-12-28
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.
Tried a DOEVENTS but no difference. I also have this after I navigate to the blank page:
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.
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)
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
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
5 Comments
Active today
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.
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.
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.
This is a subset of my code but it shows the logic of the fopen to test the release of the file.
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)
This is a subset of my code but it shows the logic of the fopen to test the release of the file.
Active today
Yes, your solution must work because the delay could be more than 5 seconds which is enough even for slow systems.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
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…
Popular third-party chat platforms like Slack, Discord, and Telegram are just a few of the many new productivity applications that are being hijacked by cybercriminals to create command-and-control (C&C) communications infrastructures for their malw…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Course of the Month7 days, 1 hour left to enroll
726 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.