Delete a file from a SQL trigger in SQLite

Question

Is it possible to delete a file from the filesystem in a SQL trigger in SQLite?

I have a table which contains the path to a file. Is it possible to create a trigger that starts when a deletion occurs and that deletes the file whose path is the one contained in the deleted row? How can I do this?

Thanks!

Community · Accepted Answer · 2017-05-23 11:47:53Z

1

You can try to create a user-defined function that will take care of deleting the file and call it from the trigger.

Here is an example: SQLiteFunction Simple Not Working

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered May 24, 2011 at 13:27

Johann Blais

9,4596 gold badges50 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Luca Carlon Over a year ago

I'm programming in C++, so following your answer I was able to refine my search and found this: blog.renanfernandes.com.br/2010/09/…. Works great! Thanks for your help!

Collectives™ on Stack Overflow

Delete a file from a SQL trigger in SQLite

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related