> --- 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.

you are referring to metadata in the main body of the database. external
tables are not under transaction control so there isn't the same type of
behaviour here.

>
> 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.
>