>>>I know this is going to sound kind of weird without going into detail...but I have an application running with it's usual database. I then open tables from another database within the application, which in turn opens that database. When I am done with it I need to close the second database. How can I specify that database to close so that the app doesn't close the main database?
>>>
>>>TIA!
>>
>>Searching through the help, there seems to be nothing similar to SELECT DATABASE. Perhaps OPEN DATABASE, for an already open database, would select the desired database?
>
>
>SET DATABASE specifies the name of an open database to be made the current database. I guess I can use that and then use CLOSE DATABASE. Does anyone know whether or not this will work?
I think this is the command I was looking for. Now, why don't they include it under "See also"?
Pressumably, CLOSE DATABASE will close the then-current (SET) database. Just try it!
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)