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 SQLco
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,
>
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 ge
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 entries.
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 Behalf
What platform is set as target for the VB.NET code (x86 / x64 / Any CPU)?
Which build of the SQLite library and the ADO.NET provider are you using?
On Wed, May 4, 2011 at 9:17 PM, kp2011 wrote:
>
> this is the vb net code I was running
>
> Dim f As New OpenFileDialog
> f.Filter = "SQLi
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 SQLite.SQLiteCommand
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
> rollback for the saf
> 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 the
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 main.
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 p
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,
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 curr
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:
> -[PointPeekViewController
> imagePickerControl
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
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 speci
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
PointPeekViewController.
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 curr
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 I
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 effec
>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 f
21 matches
Mail list logo