[sqlite] Savepoint and Begin Transaction, performance-wise

2013-05-17 Thread Paolo Bolzoni
In my programs I often use savepoints so in case of errors I can rollback leaving the db untouched. I use savepoint instead of begin transaction because it fits more naturally in the nested structure of a C program. When I write a function I do not need to recall if the caller already opened the

Re: [sqlite] Savepoint and Begin Transaction, performance-wise

2013-05-17 Thread Richard Hipp
On Fri, May 17, 2013 at 9:06 AM, Paolo Bolzoni paolo.bolzoni.br...@gmail.com wrote: In my programs I often use savepoints so in case of errors I can rollback leaving the db untouched. I use savepoint instead of begin transaction because it fits more naturally in the nested structure of a C

Re: [sqlite] savepoint

2012-01-17 Thread Csaba Jeney
Many thanks, it would help. Csaba 2012/1/16 Vivien Malerba vmale...@gmail.com 2012/1/16 Csaba Jeney csje...@genoid.hu Is there any way to query the valid savepoints? At least their names? Many thanks. AFAIK, the only way to do this is to keep track of each begin, rollback, add

[sqlite] savepoint

2012-01-16 Thread Csaba Jeney
Is there any way to query the valid savepoints? At least their names? Many thanks. Csaba This message is intended to be confidential and may be privileged. If you are not the intended recipient, please delete this e-mail from your system immediately and notify us of the erroneous transmission

Re: [sqlite] savepoint

2012-01-16 Thread Dan Kennedy
On 01/16/2012 03:31 PM, Csaba Jeney wrote: Is there any way to query the valid savepoints? At least their names? No way to do that at present. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] savepoint

2012-01-16 Thread Vivien Malerba
2012/1/16 Csaba Jeney csje...@genoid.hu Is there any way to query the valid savepoints? At least their names? Many thanks. AFAIK, the only way to do this is to keep track of each begin, rollback, add savepoint, ... executed, to always know where you are. (Anyway this is what's done in

[sqlite] savepoint error

2010-03-01 Thread Akbar Syed
I have been experiencing a strange issue with savepoint error for the library version 3.6.22. I have the following code: char* sql = SAVEPOINT sp;; char* err; slim_int ret = sqlite3_exec(sqlitehandle, sql, NULL, NULL, err); The ret is 1 which is SQLITE_ERROR and err = near \sp\: syntax error I

Re: [sqlite] SAVEPOINT : Seems don't work : SOLVED (version problem)

2009-02-25 Thread REPKA_Maxime_NeufBox
Discussion of SQLite Database Objet : Re: [sqlite] SAVEPOINT : Seems don't work On Feb 25, 2009, at 2:31 AM, REPKA_Maxime_NeufBox wrote: I try for test as follow : on DOS : sqlite3.exe Database then type : SAVEPOINT spoint; Error message is : 'SQL error :near savepoint: syntax error

Re: [sqlite] SAVEPOINT : Seems don't work

2009-02-24 Thread REPKA_Maxime_NeufBox
d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]de la part de Dan Envoye : mardi 24 fevrier 2009 05:23 A : General Discussion of SQLite Database Objet : Re: [sqlite] SAVEPOINT : Seems don't work On Feb 24, 2009, at 3:02 AM, REPKA_Maxime_NeufBox wrote

Re: [sqlite] SAVEPOINT : Seems don't work

2009-02-24 Thread Dan
On Feb 25, 2009, at 2:31 AM, REPKA_Maxime_NeufBox wrote: I try for test as follow : on DOS : sqlite3.exe Database then type : SAVEPOINT spoint; Error message is : 'SQL error :near savepoint: syntax error' Probably you need to upgrade. SAVEPOINT first appeared in 3.6.8. Dan.

[sqlite] SAVEPOINT : Seems don't work

2009-02-23 Thread REPKA_Maxime_NeufBox
Hello, I am quite new to use SQLite I tried to use SAVEPOINT command but didn't succeed Does this command work ? how ? MaxMax14 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SAVEPOINT : Seems don't work

2009-02-23 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 REPKA_Maxime_NeufBox wrote: I tried to use SAVEPOINT command but didn't succeed Does this command work ? how ? It certainly works in my testing and works in the SQLite team testing - http://sqlite.org/testing.html Chances are you haven't got

Re: [sqlite] SAVEPOINT : Seems don't work

2009-02-23 Thread Dan
On Feb 24, 2009, at 3:02 AM, REPKA_Maxime_NeufBox wrote: Hello, I am quite new to use SQLite I tried to use SAVEPOINT command but didn't succeed Does this command work ? how ? We hope so. What happened to indicate it did not succeed? In what way did the SAVEPOINT command malfunction?