Subject | Re: [firebird-support] External tables (and how to empty) |
---|---|
Author | Ivan Prenosil |
Post date | 2006-01-20T15:41:31Z |
> May be obvious, but I can't found it.External tables support only SELECT and INSERT operations,
>
> 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?
no UPDATE, no DELETE.
You can delete/modify the file - either after all users disconnect,
or when you drop external table definition.
Ivan
http://www.volny.cz/iprenosil/interbase/