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; # Op

RE: [sqlite] Error on commit

2004-01-30 Thread Williams, Ken
> Don't know anything about the DBD::SQLite extension. Is there a > separate mailing list for that? Seems like DBD::SQLite is hosted > on sourceforge, isn't it? Probably ought to ask there. There's no separate mailing list, just a bug tracker at http://rt.cpan.org/ . I know Matt reads this l

RE: [sqlite] Error on commit

2004-01-30 Thread Williams, Ken
> -Original Message- > From: Helphand [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 29, 2004 8:06 PM > To: Williams, Ken; SQLite-Users (E-mail) > Subject: Re: [sqlite] Error on commit > > > At 12:23 PM 1/29/04 -0600, Williams, Ken wrote: > > &

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 Ma

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 be

[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 pa