Thanks everyone.
As Gerrit and Mike suggested, I tried all possible ways to clear the memory.
The whole application runs without any problem under Windows 10. But under Windows 7 it fails on 2nd run.
I normally use Foxplus table with Crystal report. This is direct and does not require ADODB...
I am using the following code at the end. But this hasn't worked.
oRS.Close
oConn.Close
RELEASE oRS
RELEASE oConn
RELEASE oRpt
RELEASE oCR
The SWDAT.DBF has a Field Type = 'General' for images.
This is the reason I have to take the "vfpoledb" route.
Following is a simple piece of code. It fails on 2nd run only on Windows7 but runs well on Windows 8 and 10.
The only solution is to quit VFP9 and run the code again.
oCR = CREATEOBJECT("CrystalRuntime.Application")
oRpt = oCR.OpenReport(FULLPATH('')+"SAMPLE.RPT")
oConn =...
Following is a simple piece of code. It fails on 2nd run only on Windows7 but runs well on Windows 8 and 10.
The only solution is to quit VFP9 and run the code again.
oCR = CREATEOBJECT("CrystalRuntime.Application")
oRpt = oCR.OpenReport(FULLPATH('')+"SAMPLE.RPT")
oConn =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.