I have a class which adds local views on-the-fly to a database. Everything has worked fine until I tried to move some of methods from a top-level form to the application object. The only difference is the application uses the default datasession. The class takes care of switching datasessions so I am covered there. It appears to be a problem using the default datasession?
I can do the following is the class:
1) SET DATASESSION TO
2) SET DATABASE TO
3) Checked to make sure database is opened exclusive.
Once I issue the CREATE SQL VIEW the error occurs.
File in use.
The Database is created on-the-fly with the CREATE DATABASE.
This opens the database exclusively.
Any Ideas?
Thanks,
Bill