Re: [sqlite] Questions regaring SQLite support on N97

On 19 Jan 2010, at 2:33am, Bill King wrote: > Things are getting better, qt and qtcreator for s60's making things > noticeably easier, and there's a QtSql wrapper for the sqlite server > engine access in the works, or native sqlite is included in qt/s60 by > default. That's all good news. I

Re: [sqlite] load_extension() and extension-functions.c

On Mon, Jan 18, 2010 at 5:18 AM, Oliver Peters wrote: > Hello out there, > > I just wanted to say "thank you" for this wonderful feature (load_extension) > and > the work invested into these very useful extra functions > (extension-functions.c). Thanks! The real work on

Re: [sqlite] Questions regaring SQLite support on N97

On 01/19/2010 12:11 PM, ext Simon Slavin wrote: > On 19 Jan 2010, at 2:02am, Pedro Brigatto wrote: > > >> I would like to know if there is any way to use SQLite on Nokia N97 (I've >> been surfing on the web but got no answers to any of my questions regarding >> it yet). >> If the answer is

Re: [sqlite] Index creation in a memory database

David Alcelay wrote: > 3) create an index over this table: > create index memoria.Dispositivos_TipoDispositivo on memoria.Dispositivos > (Tipo_Dispositivo) > > I get this error: near ".": syntax error You don't specify database name in trigger name; the appropriate database is inferred

Re: [sqlite] Questions regaring SQLite support on N97

On 19 Jan 2010, at 2:02am, Pedro Brigatto wrote: > I would like to know if there is any way to use SQLite on Nokia N97 (I've > been surfing on the web but got no answers to any of my questions regarding > it yet). > If the answer is *yes*, how could I get more info to get started on > developing

[sqlite] Questions regaring SQLite support on N97

Hi, all! This is my first post on this list. Thank you in advance for your time on reading it. I would like to know if there is any way to use SQLite on Nokia N97 (I've been surfing on the web but got no answers to any of my questions regarding it yet). If the answer is *yes*, how could I get

[sqlite] BLOB handle expires when unrelated table is UPDATED!?

According to the documentation athttp://www.sqlite.org/c3ref/blob_open.html “ If the row that a BLOB handle points to is modified by an UPDATE, DELETE, or by ON CONFLICT side-effects then the BLOB handle is marked as "expired". This is true if any column of the row is changed, even a column

[sqlite] rtree_i32

Hi I found the messages on this forum giving the advice to use rtree_i32 in order to make use of integer coordinates. This is very important for the uptake of rtree among the bioinformatics community. Has it been announced whether this will become a documented feature of rtree? At the

[sqlite] Index creation in a memory database

Hi! I started having problems when I started using sqlite in 'memory' mode, this is, workin only in memory. It was not a problem to configure this working mode, it's really easy, but somethings goes wrong. So, working in no memory mode works ok, but if I go to memory mode, doesn't work with a

Re: [sqlite] BUG: .echo ON in command line tool doesn't echo all statements

On Mon, 18 Jan 2010 13:18:57 -0500, Shane Harrelson wrote: >On Fri, Jan 8, 2010 at 5:17 AM, Kees Nuyt wrote: >> > Between versions 3.6.19 and 3.6.20 something has changed >> > which causes the command line tool to ignore the .echo ON >> > command for some

Re: [sqlite] BUG: .echo ON in command line tool doesn't echo all statements

On Fri, Jan 8, 2010 at 5:17 AM, Kees Nuyt wrote: > > (Repeated with the proper BUG: subject) > > On Mon, 04 Jan 2010 19:55:13 +0100, Kees Nuyt > wrote: > > > Between versions 3.6.19 and 3.6.20 something has changed > > which causes the command line tool to

Re: [sqlite] Fossil/SQLite server is down

On Jan 18, 2010, at 2:48 AM, David Koenig wrote: > The server hosting Fossil and SQLite is down. You or the admins (if > there are admins other than you) probably know by now, but this can't > hurt. > This would be a problem at our service provider, Linode. They have been alerted to the

Re: [sqlite] load_extension() and extension-functions .c

Oliver Peters writes: > > Hello out there, > ...snip... > q1: > > I used gcc version 3.4.5 (mingw-vista special r3) to compile > "extension-functions.c" with the following options > > gcc -shared -fPIC -I "c:\Programme\SQLite" -o libsqlitefunctions.so >

[sqlite] load_extension() and extension-functions .c

Hello out there, I just wanted to say "thank you" for this wonderful feature (load_extension) and the work invested into these very useful extra functions (extension-functions.c). >From the view of a non programmer (only heavy user) I've 2 suggestions and 1 question. s1: