Subject Re: [firebird-support] External tables (and how to empty)
Author Milan Babuskov
skander_sp wrote:
> I need to export some data to external, to be imported by another
> aplication...
>
> I create a external file (sucesfully) and export the data... ok.
>
> But I can't use DELETE FROM to empty the table for next use.
>
> Where is the way?

DROP the external table, and delete/truncate the file.

http://fbexport.sourceforge.net/


Also, take a look at FBExport, might be easier to use it than external
tables:

http://fbexport.sourceforge.net/


--
Milan Babuskov
http://njam.sourceforge.net
http://www.flamerobin.org