Re: [sqlite] SAVEPOINT : Seems don't work : SOLVED (version problem)
Very good answer : That was the problem; I had 3.6.4 version : It works with the last version Thank's a lot Dan MaxMax14 -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]de la part de Dan Envoye : mercredi 25 fevrier 2009 05:28 A : General 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' Probably you need to upgrade. SAVEPOINT first appeared in 3.6.8. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ 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
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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SAVEPOINT : Seems don't work
I try for test as follow :
on DOS : sqlite3.exe Database
then type : SAVEPOINT spoint;
Error message is : 'SQL error :near "savepoint": syntax error'
I tried 'spoint', "spoint", (spoint), ('spoint'), ("spoint") : no syntax
works
With same test it works with Begin, commit and rollback
-Message 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:
> 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?
Dan.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
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
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? Dan. ___ 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
-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 your code correct, haven't called sqlite3_backup_finish or aren't checking error returns. There is complete documentation including example code at: http://www.sqlite.org/c3ref/backup_finish.html http://www.sqlite.org/backup.html Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkmjE/EACgkQmOOfHg372QSK8ACdGutrAfFeJiiDCrW36rluhpgj HroAoJfPsFICIZTZase+x96RNcNVvw8T =YRlb -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SAVEPOINT : Seems don't work
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
