> Now my only problem with CR9 is that it keeps data files open
> even after the RDC and Report objects are set to NULL.

This issue has now gone away with the following CR9 patches applied:

CR90DBEXWIN_EN_200305.exe 6-26-2003 9.0.110.5004 Monthly
CR90DEVWIN_EN_200306.exe 6-26-2003 9.0.108.5002 Monthly
CR90ACTXWIN_EN_200306.exe 6-26-2003 9.0.113.5002 Monthly
CR90DBEXWIN_EN.exe 7-10-2003 9.0.110.1074 Weekly
CR90MAINWIN_EN_200306.exe 7-29-2003 9.0.107.5002 Monthly

I'm not sure whether I should see the glass half-full or half-empty. I
fought with CR tech support over 3 weeks on this issue and the six people
that I was shuffled between aggressively denied that this was a problem, was
"by design" and would not be changed. We're in the middle of a release cycle
and this problem stopped us dead in our tracks. At best I'm disappointed in
their technical non-support, but at least the problem has gone away.

I've said it before over the years and nothing has changed - using Crystal
Reports is a hate/love relationship.


>>>P.S. CR 9 works find VFP 8 if you use ODBC and don't try and use the autoinc data type.
>>
>>We've had a couple problems with CR9 and VFP8 (don't know about CR9/VFP7):
>>
>>1. CR9 keeps data files open even after the RDC and Report objects are set to NULL. This can be reproduce via OLE DB, ODBC, VFP8, VB .NET, ACCESS. In my applications, I use temp tables for reports (I delete and recreate these tables between printouts). With CR9, it keeps the data files open and I cannot delete them unless I close out of the application - CR says this is by design, but I'm fighting it all the way to the top. In CR v7, we had to open a different report to release the data files from the previous report. In CR v8 and v8.5, the data files closed with the report (which is the way it should be!). In CR9, nothing will close the data files and I'm having to rewrite my logic to work with the tables that cannot be deleted after they've been used by a report. AARRRGGG!!!!!!
>
>Bill,
>
>I just tried doing this and didn't have any problems deleting the report table.