Re: [sqlite] Database is Locked

Is the hosting company running linux or windows? You say .net so that indicates to me windows, but I've been wrong before. (Wife lets me know frequently. {smirk}) This still "smells" like a permission issue to me. I acknowledge that you're able to read/write/modify the web files then upload

Re: [sqlite] SQL query causes various hangs/crashes/exits

One of the things I try to maintain when writing databases is that whenever I start poking at a field with WHERE, said field gets an index to its own, and then I leave it to the engine of choice (SQLite, MSSql, MySQL) to decide to use the indexes. I have rarely been let down performance wise.

Re: [sqlite] Why does analyze make this go faster?

What happens when you let the query run the first time, delete the records, then re-run the query? If the same length of time is spent (50 seconds) then I'm at a loss. If the shorter length of time happens, I'd say blame caching. On 07/13/2011 06:00 AM, Bart Smissaert wrote: > Have the

Re: [sqlite] test errors on OSX

u don't want to do that for some reason. I'd appreciate any help. Thanks, --Steve On Apr 1, 2005, at 2:54 PM, [EMAIL PROTECTED] wrote: On Apr 1, 2005, at 11:10 AM, Stephen C. Gilardi wrote: For several months now, I've gotten similar errors when I run the test on my PowerBook G4. For me, the s

Re: [sqlite] test errors on OSX

For several months now, I've gotten similar errors when I run the test on my PowerBook G4. For me, the set of tests that fail is different from test run to test run, but they do seem to be concentrated in the "*ioerr" tests for the most part. I've run the test several times on a G5 PowerMac

Re: [sqlite] quick question regarding INTEGER PRIMARY KEY default value

It is documented to start at 1: If a table contains a column of type INTEGER PRIMARY KEY, then that column becomes an alias for the ROWID. [...] If no ROWID is specified on the insert, an appropriate ROWID is created automatically. The usual algorithm is to

Re: [sqlite] Accesing database remotely

You may get it to work, but using an sqlite database file on a network file system has been reported to be troublesome. Here is a quote from in a section entitled "How To Corrupt Your Database Files": SQLite uses POSIX advisory locks to

Re: [sqlite] version 3.0.7 giving unresolved external symbol with _sqlite_free_table, _sqlite_open, _sqlite_close, _sqlite_get_table, _sqlite_exec

The prefix for several like-named routines in sqlite 3.0.7 is "sqlite3". For example: sqlite3_open Could it be that somehow you've #included "sqlite.h" instead of "sqlite3.h" in your sources? --Steve On Oct 5, 2004, at 12:45 PM, Steve Frierdich wrote: I made a static library out of the source

Re: [sqlite] api 3, bind help

The argument is a "pointer to function returning void and taking void* as its argument" (like "free"); Here's a sample program: #include void func(void (*)(void*)); void freemystuff(void* in); int main(int argc, char* argv[]) {