>I have a business logic object that passes data to an interface object using:
>
>PROCEDURE GetDataObject
>LOCAL loDataObject
>SCATTER NAME loDataObject
>RETURN loDataObject
>
>I am having a problem releasing the business logic object if I don't first release the variable that receives the returned dataobject. If I first release the receiving variable I can release the business logic object with no problems. Since this isn't a reference to an object but simply a copy of the data object I wouldn't think I should have a problem releasing the business object. Any explanations are welcomed.
>
>Bill

** Additional Information **

I have located the problem is in my data access object. When I create a connection to a VFP datasource I create a local temp database and add local views on the fly. In the destroy method of the data access object I remove the created views, close the database and then delete it. These data access classes have been in production for over a year now with no problems.

When I create a dataobject from a view in the database with SCATTER NAME and have not released it the CLOSE DATABASE command doesn't close the database so when I issue the DELETE DATABASE I get the error "File is in use."

As I said, everything works fine if I release the variable holding a copy of the dataobject before I release the data access object.

Any ideas?

Bill