General information
Category:
Coding, syntax & commands
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,
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only