Re: [sqlite] sqlite3_bind_text() and SQLITE_STATIC question

2005-05-01 Thread Greg Miller
Thomas Briggs wrote: From the looks of this warning, I would guess that you could redefine SQLITE_STATIC like this (or some variation of this that is legal C++) to solve the problem: #define SQLITE_STATIC ((extern "C" void(*)(void*)) 0) I don't think there's any legal way to do this, is t

RE: [sqlite] ASSERT in btree.c

2005-05-01 Thread Dennis Volodomanov
The strange thing is that it doesn't happen all the time, I'm trying to work out a pattern, but the schema and statement (taken out of C++ code and I had to remove the field names, because of privacy, each table contains from 4 to 60 fields) are those: "CREATE TABLE TABLE1 (\ UID INTEGER P

Re: [sqlite] backup open database

2005-05-01 Thread D. Richard Hipp
On Sun, 2005-05-01 at 00:28 +0800, Damian Slee wrote: > i want to make a copy of a sqlite3 database file while it is open. is > there anyway that i can tell programatically that any caches/journals > are flushed out? or is there any way to get and exclusive lock i > guess, before making a backup c

RE: [sqlite] SqliteExplorer and ISO8601 dates

2005-05-01 Thread Brad Schick
Great thanks. I also noticed that the format I typed below is wrong. The sqlite website (and what I actually see in the db) is: -MM-DD HH:MM:SS -Brad > -Original Message- > From: Cariotoglou Mike [mailto:[EMAIL PROTECTED] > > Will fix and let you know > >> -Original Message

RE: [sqlite] backup open database

2005-05-01 Thread Mrs. Brisby
Alrighty: embedded hardware _does_ make sense. Some options: 0. gzip the dumped database. don't save indexes, etc. Rebuild the database on startup. You can even diff against older copies if your flash has a [significantly] limited number of write cycles. this is probably the best/easiest method,

Re: [sqlite] ASSERT in btree.c

2005-05-01 Thread D. Richard Hipp
On Sun, 2005-05-01 at 16:19 +1000, Dennis Volodomanov wrote: > Hello all, > > I'm getting an assert(pCur->isValid) i Please provide the schema and an SQL statement that makes this happen. -- D. Richard Hipp <[EMAIL PROTECTED]>

RE: [sqlite] SqliteExplorer and ISO8601 dates

2005-05-01 Thread Cariotoglou Mike
Will fix and let you know > -Original Message- > From: Brad Schick [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 30, 2005 9:31 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] SqliteExplorer and ISO8601 dates > > Is it possible to get SqliteExplorer to parse textual dates in the

Re: [sqlite] OT: General SQL Question

2005-05-01 Thread Dan Keeley
Excellent worked a treat. I tried that - it didnt work, however i think i must have had a typo as it works now!!! Cheers, Dan From: "Patrick Dunnigan" <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: Subject: Re: [sqlite] OT: General SQL Question Date: Sat, 30 Apr 2005 08:20:41 -0400 Th