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
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
>
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
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
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
> -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
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;
#
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
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
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
10 matches
Mail list logo