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