Hi everyone. I just finished developing a report that processes somewhere in the vicinity of 6000 records or so. Within the Crystal Reports 9 Application it takes roughly 45-60 seconds. However, when I use the RDC ActiveX control within FoxPro, it cranks the CPU to 99% for 11 minutes. Now, I am guessing that the RDC just doesn't have the power behind it like the full blown application, which I can understand. My workaround was to display a WAIT WINDOW using a timer that refreshes every second, adding a "." to the end of the message so at least the user knows that the program is thinking, and not frozen. The problem is that when I execute the RDC's ReadRecords() method, which throws the CPU into 99% usage, it prevents my timer from firing which means the message never displays to the user.
Is there any way that I can force my timer to run in the background while Crystal is reading the database records? I looked for an event within the RDC's ActiveX Control with no success.
I look forward to any input. Thanks in advanced for your time.
________________________
Ben Santiago, MCP & A+
Programmer Analyst (SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS)
Eastern Suffolk BOCES - Student Data Services
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
-Rich Cook