Re: [sqlite] DBD::SQLite SQLite Ver 3.2.7

Eric Bohlman earlier wrote this: -- You'll need to go into dbdimp.c and change the two calls to sqlite3_prepare() so that the third argument is -1 rather than zero. This is due to the change in check-in 3047.

Re: [sqlite] C++ code sharing: import utility program for scripting and command line

"Jay Sprenkle" <[EMAIL PROTECTED]> writes: > Good afternoon all, > > I've written a utility program in vanilla C++ to help with a project. > I thought I would make it available to the community. > > If there's any interest let me know and I'll make it available. Cool. Sounds great. How about

[sqlite] EUC_JP handling in sqlite

Hi all, I guess this guery of mine is no longer related to sqlite, but maybe somebody has encountered this problem before and can help me. I have a Postgresql database with encoding set to EUC_JP. Then I have a sqlite database that is being updated every 10 minutes from data and dumps

Re: [sqlite] all

Send email to [EMAIL PROTECTED] - Original Message From: Jiao <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Wednesday, March 15, 2006 4:40:11 PM Subject: [sqlite] all I want to be off this mail list, how to do it ?

Re: [sqlite] all

Very helpfull considering that some ppl dont receive that header... me included... - Pierre - Original Message - From: "Darren Duncan" <[EMAIL PROTECTED]> To: ; "Jiao" <[EMAIL PROTECTED]> Sent: Thursday, March 16, 2006 09:47 Subject: Re: [sqlite] all At

Re: [sqlite] all

It's all in the mail headers: List-Post: List-Help: List-Unsubscribe: List-Subscribe: Make sure you send the request from the address that receives the mail... ;) Martin -

Re: [sqlite] all

At 08:40 +0800 16/3/06, Jiao wrote: I want to be off this mail list, how to do it ? Read the header of the email you sent to the list, as well as every other list message; it says there "List-Unsubscribe" plain as day. -- Darren Duncan

[sqlite] all

I want to be off this mail list, how to do it ?

Re: [sqlite] DBD::SQLite SQLite Ver 3.2.7

In order to get this to work, modify DBD::SQLite dbdimp.c so that the 3rd parameter of each call to sqlite3_prepare() is -1 instead of 0. Steve Chris Werner wrote: Hello, The current release of SQLite, 3.3.4 does not seem to be compatible with the perl DBD driver. The embedded SQLite package

[sqlite] DBD::SQLite SQLite Ver 3.2.7

Hello, The current release of SQLite, 3.3.4 does not seem to be compatible with the perl DBD driver. The embedded SQLite package works quite well, But I would like to have the full SQLite package installed [so I can use sqlite3]. I do not seem to be able to locate the source archives, I would be

[sqlite] RE:Re: [sqlite] RE: SQLite memory leak on Windows CE

Hi Robert, Thank you for your test. I have not test it on the emulator but in 4 different Windows CE devices i have at work (with different Windows CE OS versions) and it always give me the same memory leak result. I will run your test tomorrow at work using the emulator and i will let you know

[sqlite] RE:[sqlite] RE:Re: [sqlite] RE: SQLite memory leak on Windows CE

Hi again Robert, I think i forgot to tell you that to detect the memory leak you must not close the application testing program, the easiest way to detect the memory leak is: create a simple MFC dialog project. Add 2 buttons, one for executing your testing program an another one for close the

[sqlite] RE:Re: [sqlite] RE: SQLite memory leak on Windows CE

Hi Robert, Thank you for your test. I have not test it on the emulator but in 4 different Windows CE devices i have at work (with different Windows CE OS versions) and it always give me the same memory leak result. I will run your test tomorrow at work using the emulator and i will let you

RE: [sqlite] Help needed to diagnose "NOT IN" query

Hi Ulrich and Jay S. > I don't know wether it's faster, but try > > select a,b,c from d where c in (select c from d except select > c from e) > > Maybe you're lucky and it's faster. Thanks - I'll give IN a go, instead of NOT IN Cheers, David Carter-Hitchin. -- Royal Bank of Scotland

Re: [sqlite] Help needed to diagnose "NOT IN" query

Hi David, I don't know wether it's faster, but try select a,b,c from d where c in (select c from d except select c from e) Maybe you're lucky and it's faster. Kind regards Ulrich On Wednesday 15 March 2006 22:44, CARTER-HITCHIN, David, FM wrote: > Hi Brett, > > Many thanks for replying.

Re: [sqlite] Help needed to diagnose "NOT IN" query

On 3/15/06, CARTER-HITCHIN, David, FM <[EMAIL PROTECTED]> wrote: > Hi Brett, > > Many thanks for replying. Well I tried PRAGMA temp_store=memory and that > sadly did not help. > I believe the 'not in' does not use indexes, but 'in' does. Can you flip your logic?

RE: [sqlite] Help needed to diagnose "NOT IN" query

Hi Brett, Many thanks for replying. Well I tried PRAGMA temp_store=memory and that sadly did not help. I'm going to adopt a different approach. Say I've got: select a,b,c from d where c NOT IN (select c from e) What I'm trying is: 1. select a,b,c from d into a temp1 table (as far as I

[sqlite] C++ code sharing: import utility program for scripting and command line

Good afternoon all, I've written a utility program in vanilla C++ to help with a project. I thought I would make it available to the community. It reads fixed format text files and loads the result into an Sqlite3 table. The table loaded, positions of the fields within the file, and input file

[sqlite] Different behaviour on Linux vs. Windows?

Hello, I have the following scenario that fails on Linux and executes fine on Windows XP. Suppose the following SQL statement is executed by calling sqlite3_exec: SELECT mySqlFunction() Inside the body of the mySqlFuntion() the following statements are executed through calls to

Re: [sqlite] RE: SQLite memory leak on Windows CE

Ok, here's what I did ... On the desktop I created a SQLite database with one table and inserted 120,000 rows into it. I then copied it over to the CE emulator. Then I ran the following code on the CE (Pocket PC 2003 SE) emulator: #include #include #include "sqlite3.h" int WINAPI

Re: [sqlite] RE: SQLite memory leak on Windows CE

What method(s) are you using to detect the memory leak? I'll try and test this out today and see if I can come up with anything. Robert - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Wednesday, March 15, 2006 6:18 AM Subject: [sqlite] RE: SQLite

[sqlite] RE: SQLite memory leak on Windows CE

Hi again, i have tried your advice of changing line 192 at table.c and it didn´t work (it fires an exception). I do not think that the problem is related to sqlite3_get_table or sqlite3_free_table source code. To make sure, i have test it with another simple program (see the source code

Re: [sqlite] RE:Re: [sqlite] SQLite memory leak on Windows CE

On March 14, 2006 01:49 pm, [EMAIL PROTECTED] wrote: > Hello again, > Thank for your answers: > first of all thank you who pointed that i should use a close(db) at > line 17 and call sqlite3_free_table(result) even if there was an > error, but these solutions didn´t solve my problem (the