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
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
___
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
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
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
5 matches
Mail list logo