[sqlite] Fwd: In-Memory Database - problem with DROP TABLE

Dear All, I have a piece of code which is shown below, Im doing In-Memory database operation I have done these settings in SQLite, in btree.h SQLITE_DEFAULT_AUTOVACUUM = 1, TEMP_STORE=2 in sqliteint.h (this should be made compulsory, if concentrating only on in-memorydatabase, where no disk is

[sqlite] Random SQLITE_SCHEMA errors on Windows Mobile 6

I have a NETCF application that uses SQLite3 version 3.3.5. Its initialization code creates the database and several tables, and creates indexes on the tables. It works fine on devices both WinCE 4.20 (2003SE) and 5.00 (WM5), but on some 5.10 WM6 devices, it's failing. In each confirmed case so

Re: [sqlite] Re: where is SQLITE_OPEN_READONLY defined?

Ah shoot didn't realize that, thanks. Do you happen to know by any chance if opening in read-only mode improves performance at all? Or is it really just a safe-guard feature. Thanks, Mark On 9/23/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Mark Wyszomierski <[EMAIL PROTECTED]> > wrote: > >

[sqlite] Re: where is SQLITE_OPEN_READONLY defined?

Mark Wyszomierski <[EMAIL PROTECTED]> wrote: I wanted to open a sqlite database read-only - where is: SQLITE_OPEN_READONLY defined? It's new in SQLite v3.5 . Which version are you using? Igor Tandetnik - To

Re: [sqlite] test failures on cygwin

On Saturday 22 September 2007 14:20, Evans, Mark (Tandem) wrote: > It's hard to drag my Linux server to Starbucks. :-) > > Next Windows laptop, though, will definitely have to have a > Linux/Windows dual personality. I'll have to wait until the next > mega-merger for a Mac. > > Mark > If your

[sqlite] where is SQLITE_OPEN_READONLY defined?

Hi, I wanted to open a sqlite database read-only - where is: SQLITE_OPEN_READONLY defined? Thanks - To unsubscribe, send email to [EMAIL PROTECTED]