--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...>
wrote:

>
> >
> > I want to regularly replace the content of an External ascii table
> > file.
> > However Firebird is holding it open.
> > Has anyone else had this problem?
> >
>
> drop it and then re-create it
> Alan
>

We want to do this thousands/millions of times
Firebird does not like you tampering with metadata this much.
We really want firebird let us replace contents of the file
without having to drop/recreate metadata.

We have a stored proc that works off this meta data to fast inject
the data into the DB. We do not want to have to drop/recreate this
each time as well.

Regards,

Robert.