I don't think you can really want the DBC to close every time you close a table? My apps would be even slower than they are now *g*. If this is a lookup table that you use throughout your app, then why is it a problem if the DBC stays open? (I'm sure there's a reason, just curious as to what it is.)

You do the following:
USE table SHARED in 0 alias mytable
...etc
set database to (getcursorgetprop('database', 'mytable' )
CLOSE DATABASES

This will/should close just the database you're intereested in.


>How can I get around this problem?
>
>I have an application that needs to perform a lookup on a table contained in a DBC other than the DBC that I use for the app. My logic to open/close that table is as follows:
>
>USE table SHARED IN 0 ALIAS mytable
>...
>...
>IF USED("mytable")
> USE IN mytable
>ENDIF
>
>As you can image, at this point I am assuming that this lookup table has been closed. However, it appears that its parent DBC remains open and therefore creates contention for other users or apps.
>
>1. How come USE IN does not close the DBC the way it opened it?
>2. How can I make sure that I close the table and DBC?
>
>Thank you,