Re: [sqlite] new to sqlite rec'd BadImageFormatException error

I tried several different sqlite.dlls now it works Thanks kp2011 wrote: > > this is the vb net code I was running > > Dim f As New OpenFileDialog > f.Filter = "SQLite 3 (*.db)|*.db|All Files|*.*" > If f.ShowDialog() = DialogResult.OK Then > Dim

Re: [sqlite] Out of memory? How could that be on a 32G iPhone?

Hi Hartwig... I'm looking at the FMDB code, and I don't see any "open" for the d/b. Does FMDB do this for me and I'm just missing it? Also looked at Gus Mueller's blog of examples, and I don't see it there either Regards, Rolf On 5/4/11 2:38 PM, skywind mailing lists wrote: > Hi Rolf, >

Re: [sqlite] Out of memory? How could that be on a 32G iPhone?

Hi Rolf, I am using FMDB and SQLite for more than 2 years now and have not experienced any problems so far. Therefore, I expect that the bug is somewhere else but not inside SQLite (3.7.2) nor FMDB (2009-10-18). Greetings, Hartwig Am 04.05.2011 um 23:22 schrieb Rolf Marsh: > > > Prior to

[sqlite] Out of memory? How could that be on a 32G iPhone?

Prior to getting this error, I opened the d/b and inserted one (1) very small record... Where do I start looking? I am using FMDB, ZBarSDK (used to read barcodes), but I can't imagine that's using all of my memory... and I have the d/b set to be a singleton, as indicated by the NSLog

Re: [sqlite] new to sqlite rec'd BadImageFormatException error

Is it possible you're trying to load a 64 bit .dll with a 32 bit .exe? Or visa versa. Joe Mokos Sr. Software Engineer OPNET Technologies, Inc. jmo...@opnet.com (603) 598-2582 x377 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On

[sqlite] new to sqlite rec'd BadImageFormatException error

this is the vb net code I was running Dim f As New OpenFileDialog f.Filter = "SQLite 3 (*.db)|*.db|All Files|*.*" If f.ShowDialog() = DialogResult.OK Then Dim SQLconnect As New SQLite.SQLiteConnection() Dim SQLcommand As

Re: [sqlite] Page Size with NAND FLASH

On Tue, May 3, 2011 at 4:44 PM, Sugathan, Rupesh wrote: > I am planning to use sqlite on a Linux system with JFFS2 file system on > NAND flash. NAND device that I am using has page size of 2048 bytes and > a erase sector size of 128K. I would like to take advantage of sqlite

Re: [sqlite] INNER JOIN Optimization

> The problem is that I would like to avoid splitting the query into two parts. > I would expect SQLite to do the same thing for me automatically (at least in > the second scenario), but it does not seem to happen... Why is that? In short, because SQLite cannot read your mind. To understand

[sqlite] INNER JOIN Optimization

Hello. I have two tables to join. TABLE_A (contains column 'a') and TABLE_BC (contains columns 'b' and 'c'). There is a condition on TABLE_BC. The two tables are joined by 'rowid'. Something like: SELECT a, b, c FROM main.TABLE_A INNER JOIN main.TABLE_BC WHERE (b > 10.0 AND c < 10.0) ON

Re: [sqlite] Virtual tables and OR clause

On 05/04/2011 08:58 PM, Schrum, Allan wrote: > Hi Folks, > > Using virtual tables the WHERE clause is broken up and sent to the "best > index" function to determine the best index. Then the "filter" function is > called to perform the actual work. I've noticed that the SQLITE engine seems > to

[sqlite] Virtual tables and OR clause

Hi Folks, Using virtual tables the WHERE clause is broken up and sent to the "best index" function to determine the best index. Then the "filter" function is called to perform the actual work. I've noticed that the SQLITE engine seems to process OR clauses outside of the virtual table process,

Re: [sqlite] How do I make a "singleton" using FMDB?

I think I figured it out on my own (a good night's sleep helps!)... thanks everybody... R On 5/3/11 4:14 PM, Rolf Marsh wrote: > I'm having a hard time changing my Obj-C SQLite3 code to FMDB... the > code works (after a fashion), but I need it to be a singleton (my > current SQLite3 code is

Re: [sqlite] Getting an error 21 when doing a sqlite3_prepare_v2

On Tue, May 3, 2011 at 10:29 AM, Rolf Marsh wrote: > Good Morning Richard... thanks for the response... after making the > change you suggested and when doing the build, I get the following error: > > > > > l "_sqlite3MisuseError", referenced from: >

[sqlite] BUG: incremental_vacuum in combination with SQLITE_FCNTL_CHUNK_SIZE

With respect to SQLite 3.7.6 Situation: - incremental vacuum mode - old "journal" mode (have not tested with WAL) - extra tail-room using SQLITE_FCNTL_CHUNK_SIZE - some free pages - execute PRAGMA incremental_vacuum Problem: - the journal will be created for all extra tail pages This is just a

[sqlite] Feature request: Fuzzy searching

Hi all, I am interested in seeing "fuzzy searching" in SQLite, for lack of a better term. This type of search would return more results than LIKE currently does today. The search would return matches based on expanded criteria, each one may be considered a separate RFE for LIKE or for another

Re: [sqlite] Getting an error 21 when doing a sqlite3_prepare_v2

Good Morning Richard... thanks for the response... after making the change you suggested and when doing the build, I get the following error: l "_sqlite3MisuseError", referenced from: -[PointPeekViewController imagePickerController:didFinishPickingMediaWithInfo:] in

Re: [sqlite] Feature request: Fuzzy searching

I apologize if double-post, the first one didn't make it to the list. - Hi, >Hi all, I am interested in seeing "fuzzy searching" in SQLite, for >lack of a better term. This type of search would return more results >than LIKE

[sqlite] NAND flash whit lot of writes (erases)

I found few topics on this issue but still. For instance from here http://www.mail-archive.com/sqlite-users@sqlite.org/msg54904.html. I have similar problem of writing multiple small data (max 100bytes per entry), but do not think that those advices from upper link were right. I have to tell that

Re: [sqlite] Advice to choose an index for quad tree?

I found the R-Tree idea fascinating. Conceptually, this is exactly what I need. But indeed, my case is very simple: my dataset is not sparse, my tiles never overlap (for a given zoom factor), the number of tiles is still rather small, they are all rectangular and the same size (modulo edge

Re: [sqlite] Page Size with NAND FLASH

>From here http://download.micron.com/pdf/datasheets/flash/nand/2gb_nand_m29b.pdf you can se what PAGE_SIZE is Page size is smallest writeable unit. Technically you can write less multiple times but as far as I know jffs2 does not use this technique, but lot of other flash file systems does (jffs