Re: [sqlite] Am I understanding how to use ROLLBACK - SAVEPOINT correctly?

2019-02-13 Thread Scott
Andy, David, Tim!!! Thanks for the help and advice... I think I will name mine "theKraken"... ;) LOL! Scott ValleryEcclesiastes 4:9-10 On Wednesday, February 13, 2019, 10:34:51 AM EST, Tim Streater wrote: On 13 Feb 2019, at 15:23, David Raymond wrote: > On a humor tangent, am I the

Re: [sqlite] Am I understanding how to use ROLLBACK - SAVEPOINT correctly?

2019-02-13 Thread Tim Streater
On 13 Feb 2019, at 15:23, David Raymond wrote: > On a humor tangent, am I the only person who has ever named a savepoint > "theHounds" for the sole purpose of being able to run the statement: > > release theHounds; welease Bwian; -- Cheers -- Tim ___

Re: [sqlite] Am I understanding how to use ROLLBACK - SAVEPOINT correctly?

2019-02-13 Thread David Raymond
eing able to run the statement: release theHounds; ? :) -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Andy Bennett Sent: Wednesday, February 13, 2019 9:58 AM To: SQLite mailing list Subject: Re: [sqlite] Am I understanding

Re: [sqlite] Am I understanding how to use ROLLBACK - SAVEPOINT correctly?

2019-02-13 Thread Andy Bennett
Hi, For example, would I do this: Connect to the DB [ Pass the command to save: ]SAVEPOINT 'current' [ User choices are processed: SELECT and UPDATE statements ] [ if error or user changes their mind ]    ROLLBACK TRANSACTION TO SAVEPOINT 'current' [ otherwise... upon success ]    RELEASE S

[sqlite] Am I understanding how to use ROLLBACK - SAVEPOINT correctly?

2019-02-13 Thread Scott
Hi All! I've been reading about SAVEPOINT and ROLLBACK in the SQLite documentation. My project has an embedded SQLite DB with multiple tables (relational) that may or may not be read or updated because of choices the user makes.  Am I understanding correctly that I can use these commands to rol