Re: [sqlite] Write to a View

2012-11-11 Thread BareFeetWare
Hi Marco, I know we've been discussing this directly, but since you've also mentioned it here on this list, I thought a response here could also facilitate greater discussion. An updatable view is a view that will accept insert, delete and update commands, propagating changes back to the under

Re: [sqlite] Write to a View

2012-11-09 Thread Clemens Ladisch
Marco Bambini wrote: > From the official documentation: > You cannot DELETE, INSERT, or UPDATE a view. Views are read-only in SQLite. > However, in many cases you can use an INSTEAD OF trigger on the view to > accomplish the same thing. > > Can someone clarifies this point? > Seems like it is poss

[sqlite] Write to a View

2012-11-09 Thread Marco Bambini
>From the official documentation: You cannot DELETE, INSERT, or UPDATE a view. Views are read-only in SQLite. However, in many cases you can use an INSTEAD OF trigger on the view to accomplish the same thing. Can someone clarifies this point? Seems like it is possible to write into a view but I d