Closing Databases

[hayv]

Is there anyway of closing an individual database, without the Close Databases command closing all free tables, when and when not a database is open and current. Would appreciate any help, can´t find anything in help or VFP manuals about it.

 

[Walid]

Hi my friend,

Is there anyway of closing an individual database, without the Close Databases command closing all free tables, when and when not a database is open and current

Close Databases command DOESN'T close all free tables when and when not a database is open and current. I think you misunderstood this command.
When you have a database opened and also free tables opened,
issuing the command

Close Databases

close only the current database and leave your free tables open and untouched. You just have to make sure that your database is the currently selected one before you issuing

Close Databases

command.
To do this, use the command

SET DATABASE TO Your_DataBaseName

Then when you use

Close Databases

, you will find that the data base "Your_DataBaseName" is closed but your free tables and the other databases opened [if any]
still open and this command DOESN'T affect them.
Hope this will help you my friend. Walid Magd
Engwam@Hotmail.com

 

[hayv]

Thanks Walid for your help, let me try this out then.