Subject Re: Replacing Content of External Files
Author robertgilland
> What version are you using? I have a vague memory that this was
fixed in
> some FB version. I suggest checking the detailed logs.

I use Firebird 1.5.1.4481

>
> Also what I do is *overwrite* the ASCII file rather that recreate
it.
> Mostly in my case this is done with WinAPI from a Delphi program on
the
> same server via a Samba setup.

Any more info here. It would be great if I could do this.
By simply overwriting the file. Without being locked out
of it by Firebird.

>
> I am quite positive (after a fast check) that I don't have to do
any DDL
> between cycles. After a complete restore, though, there are almost
> always small problems and I often have to recreate the table.
>

Because the Stored Proc refers to the external table and it is
Metadata. I do not want to have to drop the external table.

Regards,

Robert.