Thanks, I'll try it

--- In firebird-support@yahoogroups.com, "davidalbiston" <mail@D...>
wrote:

>
> Dorin
>
> You need to drop the external table (this does not delete the file).
>
> Dave
>
> --- In firebird-support@yahoogroups.com, "Dorin Vasilescu"
> <dorin_vas@y...> wrote:
> >
> > Hi all
> > Is there a way to close a file handle of an external table file for
> > embedded server?
> >
> > I've tried to speed up things by storing static and lookup data in a
> > local database and to get only transactional data over the wire (DSL
> > connection). Then get all that is needed for presentation in UI or
> > reports with a join between an external table filled with remote data
> > (ids mainly) and tables from local database, using the embedded

server.

> >
> > It works well and very fast, but only first time :(
> > At the second attempt to fill the external table file, it fails,
> > because the file is open.
> >
> > Any ideas?
> >
> > Or another approach?
> >
> > Thanks in advance