> -----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 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; > # Optionally... > $dbh->{AutoCommit} = 1;
Right, I've made that change (see a previous message) but it doesn't seem to have any effect on this situation. The real problem seemed to be that I was out of disk space, and the SQLite error message to that effect (if any) was missing. -Ken --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
