Issue Details (XML | Word | Printable)

Key: CORE-693
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Pavel Cisar
Votes: 4
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Ability to clear/delete External Tables

Created: 17/Sep/03 12:00 AM   Updated: 16/Oct/17 02:27 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None

Issue Links:
Duplicate
 

SF_ID: 807975


 Description  « Hide
SFID: 807975#
Submitted By: pcisar

Like the ZAP (dBase) command, users would like clear
the contents of an External table or delete the table
completely.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Fergus McDonald added a comment - 05/Jan/07 02:24 PM
Perhaps this could be implemented by allowing DELETE FROM on the external table, such that it would truncate the external file to 0 bytes.

Sean Leyne added a comment - 03/Jun/09 06:09 PM
There are a number of comments which were added to case Core-1584, which should be considered when reviewing/implementing this feature.

Vlad Khorsun added a comment - 03/Jun/09 10:45 PM
Sean, does you mean CORE-1564 ?

Volker Rehn added a comment - 16/Oct/17 02:27 PM
this is not a duplicate of http://tracker.firebirdsql.org/browse/CORE-1564.
This feature request asks for a way to *empty the file* hooked via external table by doing DELETE FROM <external table>

This would make it possible to edit a file by rewriting it (read data from file, modify data somewhere, delete file content, then insert modified data)
Right now one can only read and append.