Re: [sqlite] Unexpected cascading delete

2011-01-12 Thread Duquette, William H (318K)
Richard, I was afraid you were going to tell me that; it makes all too much sense, once I thought about. Thanks for the definitive word. Will On 1/12/11 2:08 PM, "Richard Hipp" wrote: On Wed, Jan 12, 2011 at 4:54 PM, Duquette, William H (318K) <

Re: [sqlite] Unexpected cascading delete

2011-01-12 Thread Richard Hipp
On Wed, Jan 12, 2011 at 4:54 PM, Duquette, William H (318K) < william.h.duque...@jpl.nasa.gov> wrote: > I've just discovered that a REPLACE can trigger a > cascading delete. Is this expected behavior? > > I have an undo scheme where I grab entire rows from the > database before they are changed;

Re: [sqlite] Unexpected cascading delete

2011-01-12 Thread Gerry Snyder
On 1/12/2011 2:54 PM, Duquette, William H (318K) wrote: > I've just discovered that a REPLACE can trigger a > cascading delete. Is this expected behavior? > > I have an undo scheme where I grab entire rows from the > database before they are changed; then, on undo I > simply put the rows back

[sqlite] Unexpected cascading delete

2011-01-12 Thread Duquette, William H (318K)
I've just discovered that a REPLACE can trigger a cascading delete. Is this expected behavior? I have an undo scheme where I grab entire rows from the database before they are changed; then, on undo I simply put the rows back using "INSERT OR REPLACE". My assumption was that doing a REPLACE was