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