Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Ability to clear/delete External Tables [CORE693] #1060

Open
firebird-automations opened this issue Sep 17, 2003 · 6 comments
Open

Ability to clear/delete External Tables [CORE693] #1060

firebird-automations opened this issue Sep 17, 2003 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pcisar

Is duplicated by CORE1564

Votes: 4

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: Fergus McDonald (fergusm)

Perhaps this could be implemented by allowing DELETE FROM on the external table, such that it would truncate the external file to 0 bytes.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10717 ] => Firebird [ 15042 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue is duplicated by CORE1564 [ CORE1564 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

There are a number of comments which were added to case Core-1584, which should be considered when reviewing/implementing this feature.

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Sean, does you mean CORE1564 ?

@firebird-automations
Copy link
Collaborator Author

Commented by: Volker Rehn (vr2_s18)

this is not a duplicate of CORE1564.
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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants