Re: Re: [sqlite] DELETE row problem

first,thanks for your answer. in my application, i port sqlite 3.3.12 base on the OS named OS20 supported by ST and a flash FS developed by our team. them i just open a DB(flash_db) and PRAGMA it, PRAGMA temp_store = MEMORY; PRAGMA synchronous = NORMAL; after that,i creat table(flash_tabel)

Re: [sqlite] Fortran 95 Language Bindings

Hi, CVF initially. I will likely transition to IVF once a suitable version is released. Arjen Markus <[EMAIL PROTECTED]> wrote: Gary Scott wrote: > > I do not possess a C compiler, so I will need an all-Fortran solution, > unless the C interface is provided as a compiled binary. > What

Re: [sqlite] trim available ??

Dennis Cote wrote: Stef Mientki wrote: I don't know which version I'm running, how can I detect that ? Stef, You can call sqlite3_libversion (see http://www.sqlite.org/capi3ref.html#sqlite3_libversion for details). Thanks Dennis, Yes, I see now, I've 3.3.8 ;-) cheers, Stef Mientki

Re: [sqlite] trim available ??

Liam Healy wrote: An option for versions that do not have trim is http://sqlite.org/contrib//download/extension-functions.tgz?get=17 thanks Liam, but I think it's better to recreate the database, with trimmed itesm. cheers, Stef

Re: [sqlite] Auto Vaccum and fragmentation?

Ludvig Strigeus uttered: Assuming I have an autovacuum database that primarily stores 32k blobs. If I add/remove lots of rows, will this lead to excessive fragmentation of the overflow chains, or does Sqlite do anything to try to unfragment the pages belonging to a single row? I believe

Re: [sqlite] trim available ??

Stef Mientki wrote: I don't know which version I'm running, how can I detect that ? Stef, You can call sqlite3_libversion (see http://www.sqlite.org/capi3ref.html#sqlite3_libversion for details). HTH Dennis Cote

Re: [sqlite] handling empty table in a callback function to sqlite3_exec

Hi, I'm querying a table by writing the query in sqlite3_exec with a callback function that does some operation on the resulting row. Everything is fine when the table has even one row, but when it is empty, my program halts with "segmentation fault". I can add a dummy row to the table to prevent

Re: [sqlite] trim available ??

An option for versions that do not have trim is http://sqlite.org/contrib//download/extension-functions.tgz?get=17 On 4/16/07, Stef Mientki <[EMAIL PROTECTED]> wrote: > The TRIM function was added on 2007-03-17 17:52:42. > Thanks, that explains .. cheers, Stef > -- > D. Richard Hipp <[EMAIL

Re: [sqlite] #define confliction

from 3.3.15, sqlite3's sources are combinded into one sqlite3.c (in sqlite-source-3_3_15.zip). when I compile this on VC++8, a warning is reported: ... It's just a warning. Ignore it. Is it a harmless warning? however, I don't wanna be surprised. hope to replace another macro such as

Re: [sqlite] #define confliction

"FUKUDA, Fumiki" <[EMAIL PROTECTED]> wrote: > from 3.3.15, sqlite3's sources are combinded into one sqlite3.c (in > sqlite-source-3_3_15.zip). > when I compile this on VC++8, a warning is reported: > > sqlite3.c(56983) : warning C4005: 'ARRAYSIZE' : macro re-defined. >

Re: [sqlite] trim available ??

The TRIM function was added on 2007-03-17 17:52:42. Thanks, that explains .. cheers, Stef -- D. Richard Hipp <[EMAIL PROTECTED]> Kamer van Koophandel - handelsregister 41055629 / Netherlands Chamber of Commerce - trade register 41055629

[sqlite] #define confliction

from 3.3.15, sqlite3's sources are combinded into one sqlite3.c (in sqlite-source-3_3_15.zip). when I compile this on VC++8, a warning is reported: sqlite3.c(56983) : warning C4005: 'ARRAYSIZE' : macro re-defined. ...VC\PlatformSDK\include\winnt.h(950) : 'ARRAYSIZE' so I modified sqlite3.c

Re: [sqlite] trim available ??

Stef Mientki <[EMAIL PROTECTED]> wrote: > Mohd Radzi Ibrahim wrote: > > Hi, > > I'm running 3.3.15. No problem at all. Maybe your version does not > > have this implemented yet... > > > > I use the SQLITE3.DLL dated 8 october 2006 The TRIM function was added on 2007-03-17 17:52:42. -- D.

Re: [sqlite] trim available ??

Mohd Radzi Ibrahim wrote: Hi, I'm running 3.3.15. No problem at all. Maybe your version does not have this implemented yet... I don't know which version I'm running, how can I detect that ? I use the SQLITE3.DLL dated 8 october 2006, but windows can't find the version info in that file.

Re: [sqlite] trim available ??

Hi, I'm running 3.3.15. No problem at all. Maybe your version does not have this implemented yet... best regards, Radzi. - Original Message - From: "Stef Mientki" <[EMAIL PROTECTED]> To: Sent: Monday, April 16, 2007 10:14 PM Subject: [sqlite] trim available

[sqlite] trim available ??

hello, As I read here http://www.sqlite.org/lang_expr.html there are trim functions availabel as part of an expression. But when I try to execute the next statement: SELECT App FROM PO WHERE LOWER(App_Type) = TRIM(LOWER('{ Afzuigapparaat } ')) I get the following error / ERROR

[sqlite] SQL Close issues

Hi all, Sqlite gives an error "Unable to close due to unfinalised statements" if there are any active VM's while we try to close sqlite. Will there be any error (for eg, memory leak and others) if we don't check the condition and try to close the sqlite? The

Re: [sqlite] Fortran 95 Language Bindings

Arjen, The project I was working on was part of a larger effort to port a suite of software which included Fortran programs that connect to Oracle (using Pro*Fortran). Some of it we ported earlier by rewriting the database access portions in C. One of the alternatives to sqlite3 bindings for

Re: [sqlite] Fortran 95 Language Bindings

Gary Scott wrote: I do not possess a C compiler, so I will need an all-Fortran solution, unless the C interface is provided as a compiled binary. What Fortran compiler do you prefer? I can supply a precompiled C library that should be suitable for a number of Fortran compilers (CVF, IVF on

Re: [sqlite] Fortran 95 Language Bindings

Arjen Markus wrote: Gary Scott wrote: Liam Healy wrote: I am very interested in this for a project of increasing urgency. A few months ago I found the two links that the other emails mentioned, but found both of them inadequate and not well documented. I think a complete, documented F95

Re: [sqlite] Error by Creating a Transaction (Sorry ErrorMessage in German)

Oh no I'm so stupid , in the functions concerned has I that open the Connection forgotten. "SQLiteConn.Open()" g.. It is not a Bug in Ado.Net-Provider, it is a Bug in my Brain. CLOSED -- View this message in context:

Re: [sqlite] Error by Creating a Transaction (Sorry ErrorMessage in German)

Hello, i have new information to this Error. I have make an new Projekt with a new Database. The Error begins by Create Connection: Source: Private Sub Read_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ReadDB.Click Dim FileName As String =

Re: [sqlite] Fortran 95 Language Bindings

Gary Scott wrote: Liam Healy wrote: I am very interested in this for a project of increasing urgency. A few months ago I found the two links that the other emails mentioned, but found both of them inadequate and not well documented. I think a complete, documented F95 API would be very

[sqlite] Auto Vaccum and fragmentation?

Assuming I have an autovacuum database that primarily stores 32k blobs. If I add/remove lots of rows, will this lead to excessive fragmentation of the overflow chains, or does Sqlite do anything to try to unfragment the pages belonging to a single row? Thanks, Ludvig