Subject Re: External tables (and how to empty)
Author Adam
--- In firebird-support@yahoogroups.com, "skander_sp"
<skander_sp@y...> wrote:
>
> Tks Dave...
>
> The idea was to delete from a procedure before refill the table, but I
> see the firebird can do this way...
> But having locked the acces for himseft, it's a pity can delete from
> inside!! (I think is logic ans usefull... and no way)
>
> ok, I try to resolve from outside
>
> it's posible to call from inside a procedure to delete a file?
> I think I ast for to much...

I am not too sure if the event will help, because it will not fire
until after the transaction commits, but you could use a UDF call to
delete the file. Alternatively, you put the onus on the other software
to delete (or rename) the file once imported.

Adam

>
>
> --- In firebird-support@yahoogroups.com, "davidalbiston" <mail@D...>
> wrote:
> >
> > 1) Drop the table from the database
> > 2) Delete the file from the machine
> > 3) Recreate the table
> >
> > Dave
>