[sqlite] Database Full!

Hi, I am trying to handle a problem that occurs when the disk is full: when i try to insert, that return SQLITE_FULL.   Ok.   There is not problem to get some elements from the database.   Then I try to remove some elements... But that returns SQLITE_BUSY!   I have tryed to stop all operation

Re: [sqlite] Database Full!

Benoit Gantaume wrote: Hi, I am trying to handle a problem that occurs when the disk is full: You could pop up a message telling the user to stop surfing for pr0n and delete some of his jpegs. - To unsubscribe, e-mail: [EMAIL P

Re: [sqlite] Database Full!

Benoit Gantaume wrote: Hi, I am trying to handle a problem that occurs when the disk is full: when i try to insert, that return SQLITE_FULL. Ok. There is not problem to get some elements from the database. Then I try to remove some elements... But that returns SQLITE_BUSY! I have tryed to s

[sqlite] Exception in 'EXPR.C'

The following command: SELECT * FROM colours WHERE db.colours.code = 123 produces an exception in Windows, with sqlite 2.8.12. The exception occurrs here in EXPR.C: static int lookupName(..) ... if( zDb!=0 && sqliteStrICmp(db->aDb[pTab->iDb].zName, zDb)!=0 ) ###HERE### { c

Re: [sqlite] Exception in 'EXPR.C'

On Feb 16, 2004, at 8:27 AM, Luciano wrote: SELECT * FROM colours WHERE db.colours.code = 123 produces an exception in Windows, with sqlite 2.8.12. The exception occurrs here in EXPR.C: static int lookupName(..) ... if( zDb!=0 && sqliteStrICmp(db->aDb[pTab->iDb].zName, zDb)!=0 ) ###HERE#

Re: [sqlite] Exception in 'EXPR.C'

It's alright, thanx ! Luciano - Original Message - From: "Will Leshner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 16, 2004 1:35 PM Subject: Re: [sqlite] Exception in 'EXPR.C' > > On Feb 16, 2004, at 8:27 AM, Luciano wrote: > > > SELECT * FROM colours WHERE db.

[sqlite] How do I create a log of SQLite SQL statements, etc?

I'd like to be able to see all the sql traffic going to/from my sqlite database. Is there a way to run things in a debug mode so that it outputs the sql traffic to a log file, similar to how you'd do it in Postgres? Scott -

Re: [sqlite] How do I create a log of SQLite SQL statements, etc?

At 11:47 AM -0800 2/16/04, Scott Chapman wrote: I'd like to be able to see all the sql traffic going to/from my sqlite database. Is there a way to run things in a debug mode so that it outputs the sql traffic to a log file, similar to how you'd do it in Postgres? Scott This may not be the answer y

Re: [sqlite] How do I create a log of SQLite SQL statements, etc?

Scott Chapman wrote: I'd like to be able to see all the sql traffic going to/from my sqlite database. Is there a way to run things in a debug mode so that it outputs the sql traffic to a log file, similar to how you'd do it in Postgres? You can do this with the sqlite_trace() API. The only do

Re: [sqlite] How do I create a log of SQLite SQL statements, etc?

Scott Chapman wrote: I'd like to be able to see all the sql traffic going to/from my sqlite database. Lookup "sqlite_trace" in sqlite.h - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTEC

[sqlite] PRAGMA show_datatypes is now ON by default

The show_datatypes PRAGMA is now locked on. The datatype names always appear as the second "argc" entries of the "columnNames[]" parameter to the sqlite_exec() callback. Attempts to turn the datatypes off using the PRAGMA will be unsuccessful. The datatypes are always there. The datatypes have al

Re: [sqlite] PRAGMA show_datatypes is now ON by default

On Feb 16, 2004, at 1:15 PM, D. Richard Hipp wrote: The show_datatypes PRAGMA is now locked on. The datatype names always appear as the second "argc" entries of the "columnNames[]" parameter to the sqlite_exec() callback. Attempts to turn the datatypes off using the PRAGMA will be unsuccessful.

Re: [sqlite] PRAGMA show_datatypes is now ON by default

"D. Richard Hipp" <[EMAIL PROTECTED]> writes: > The show_datatypes PRAGMA is now locked on. The datatype > names always appear as the second "argc" entries of the > "columnNames[]" parameter to the sqlite_exec() callback. > Attempts to turn the datatypes off using the PRAGMA will > be unsuccessfu

Re: [sqlite] PRAGMA show_datatypes is now ON by default

[EMAIL PROTECTED] wrote: "D. Richard Hipp" <[EMAIL PROTECTED]> writes: The show_datatypes PRAGMA is now locked on. Is this going to break anybody's code? Yes, I think so, if I understand this change correctly. I don't use any pragmas at all, and I always get the first row of my data beginning in

Re: [sqlite] PRAGMA show_datatypes is now ON by default

"D. Richard Hipp" <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: >> "D. Richard Hipp" <[EMAIL PROTECTED]> writes: >>> The show_datatypes PRAGMA is now locked on. Is this going to break >>> anybody's code? >> Yes, I think so, if I understand this change correctly. I don't use any >> pragma

[sqlite] Mailing List Archives

Hi, Can any body give me a single line instruction on how to search the mailing list archive. I could do that when we were still using the yahoo group. I sent a mail to [EMAIL PROTECTED] and could not get much help. Thanks. Chris. - BT Y