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