Re: [sqlite] Error: cannot commit - no transaction is active

2014-01-31 Thread jose isaias cabrera
Clemens Ladisch" wrote... jose isaias cabrera wrote: I would like to suggest that once a BEGIN is set, if there is a syntax error after a BEGIN, that BEGIN gets deactivated. This is not how the SQL standard says databases should work. sqlite> begin; sqlite> select foo FROM; Error: near

Re: [sqlite] Error: cannot commit - no transaction is active

2014-01-31 Thread Clemens Ladisch
jose isaias cabrera wrote: > I would like to suggest that once a BEGIN is set, if there is a syntax > error after a BEGIN, that BEGIN gets deactivated. This is not how the SQL standard says databases should work. > sqlite> begin; > sqlite> select foo FROM; > Error: near ";": syntax error >

[sqlite] Error: cannot commit - no transaction is active

2014-01-31 Thread jose isaias cabrera
Greetings! Perhaps I have not right ask this, as I am a newbie to SQL (about 5 years), but, I would like to suggest that once a BEGIN is set, if there is a syntax error after a BEGIN, that BEGIN gets deactivated. For example: sqlite> begin; sqlite> select foo FROM; Error: near ";": syntax

Re: [sqlite] SQLite error: cannot commit transaction - SQL statements in progress

2009-06-26 Thread Igor Tandetnik
Manasi Save wrote: > I am working on an application. In my code nowhere I am explicitly > setting AutoCommit = False after any statement. You set AutoCommit = False by executing BEGIN statement. You set it back to True by executing COMMIT, END or ROLLBACK. > But i am getting &quo

[sqlite] SQLite error: cannot commit transaction - SQL statements in progress

2009-06-26 Thread Manasi Save
Hi All, I am working on an application. In my code nowhere I am explicitly setting AutoCommit = False after any statement. But i am getting "SQLite error: cannot commit transaction - SQL statements in progress" this error. Can anyone provide any input on this case in which all sene

RE: [sqlite] Error on commit

2004-02-02 Thread Williams, Ken
> -Original Message- > From: Matt Sergeant [mailto:[EMAIL PROTECTED] > Sent: Monday, February 02, 2004 4:26 AM > To: Williams, Ken > Cc: SQLite-Users (E-mail) > Subject: Re: [sqlite] Error on commit > > > On 29 Jan 2004, at

Re: [sqlite] Error on commit

2004-02-02 Thread Matt Sergeant
On 29 Jan 2004, at 18:23, Williams, Ken wrote: create_new_sqlite_database(); $dbh->do("BEGIN"); add_lots_of_rows_to_lots_of_tables(); $dbh->do("COMMIT"); Change to: create_new_sqlite_database(); $dbh->{AutoCommit} = 0; add_lots_of_rows_to_lots_of_tables(); $dbh->commit; #

Re: [sqlite] Error on commit

2004-01-29 Thread Helphand
At 12:23 PM 1/29/04 -0600, Williams, Ken wrote: create_new_sqlite_database(); $dbh->do("BEGIN"); add_lots_of_rows_to_lots_of_tables(); $dbh->do("COMMIT"); The correct syntax is; $dbh->begin_work; $dbh->commit; Try them. Scott Utilities for POPFile, the OpenSource

Re: [sqlite] Error on commit

2004-01-29 Thread D. Richard Hipp
Williams, Ken wrote: Hi, I'm using DBD::SQLite compiled with SQLite version 2.8.11. I'm getting the following error, with RaiseError => 1: DBD::SQLite::db do failed: at load_db.pl line 27, <$in_file> line 220663. (Line 27 is simply $dbh->do("COMMIT"); ) So, A) Why isn't the error string

[sqlite] Error on commit

2004-01-29 Thread Williams, Ken
Hi, I'm using DBD::SQLite compiled with SQLite version 2.8.11. I'm getting the following error, with RaiseError => 1: DBD::SQLite::db do failed: at load_db.pl line 27, <$in_file> line 220663. (Line 27 is simply $dbh->do("COMMIT"); ) So, A) Why isn't the error string being displayed as