Ann,

Might it be possible to have it keep track of statement handles with
prepared statements that access the external table? This would make it so
that is all people would have to do is Unprepare the statements making use
of the external table and then the file handle should be released. Isn't
this the level where the "Object is in Use" contention comes from?

FWIW,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Ann Harrison" <harrison@...>
To: <IB-Architect@egroups.com>
Sent: Thursday, June 15, 2000 5:48 PM
Subject: [IB-Architect] External file handling


> In the superserver architecture, the server opens external
> files on demand, but never closes them. Would there be a
> problem, either in compatibility or in code, with keeping
> a counter and closing the file shortly after the last
> connection that referenced the file had exited?
>
> Ann