is there a way to find out if a particular table is being use?
and how do you can find out if a record is beig use (del, insert, update)

regards,

Bre-x

The DTI Interface provides functions to check on a file.

You can check a single record by trying to lock the record first, then
calling the StatExtended function to find out who the lock holder is. I

've written my own application called FindLock that can iterate over a data
set and find out which user has which records locks, but it must still hit
every record in the database. An application that hits a record lock has the
first part done -- and can simply call the Extended Stat call to find out the
other details.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 16-19, 2004: See our web site for details!



Bre-x wrote:

In Windows 2000 or newer you can right click on my computer and Select
Manage. Then go to Shared Folders>> Open Sessions. You can close a file
there also.

"Bill Bach" <bbach (AT) cncdsl (DOT) com> wrote

If you see a file open in the Windows manager then it is not open by
the database engine on the server. The Windows manager only shows
files open across the network. As the Pervasive.SQL database engine
is client / server in nature the file (as shared by windows) should
not be open as it should be open locally by the database engine.

Even if you see it open there I would not recomend just closing it
like that. While the database engine does do a multi-phase file
commit if file IO is suddenly blocked or stopped there is the chance
(small as it is) of file corruption.

BTW, the network shared open file list goes back to at least WFW 3.11
if you know where to look.

Leonard

On Wed, 23 Feb 2005 16:54:14 -0600, "Scott817" <Scott (AT) capauto (DOT) com>
wrote: