RE: [sqlite] problems compiling 3.2.6

Or download the CVS version, it has already been fixed by drh in there! -Oorspronkelijk bericht- Van: Maurizio Ferraris [mailto:[EMAIL PROTECTED] Verzonden: dinsdag 20 september 2005 15:13 Aan: sqlite-users@sqlite.org Onderwerp: Re: [sqlite] problems compiling 3.2.6 I also have the same

[sqlite] Speed.html

Hi, I just redid the speedtest.tcl-script in PHP (http://www.karels0ft.be/tmp/speed_script.html). Can anyone check why the SQLite3's are so slow compared to SQLite2's ? This script maybe could be used by someone with too much time to check up the timings of the latest versions, to

[sqlite] BEGIN; - clausule

Hi, When I was using 2.8, i could do the following: BEGIN ON CONFLICT IGNORE; As of v3 it seems this is gone? Is there any way to achieve the same, but not to add it to EVERY query in the transaction? Thanks, Steven

Re: [sqlite] Clearing of memory

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mime-Version: 1.0 Content-Type: multipart/mixed; x-avg-checked=avg-ok-786B32B5; boundary="===733C1D2===" - --===733C1D2=== Content-Type: multipart/alternative; x-avg-checked=avg-ok-786B32B5;

Re: [sqlite] Clearing of memory

't cleared... Probably I'm doing something wrong with the query, but that doesn't mean I cannot clear the memory right? Cheers, Steven At 13:01 3/12/2004, you wrote: Steven Van Ingelgem wrote: Hi, Another question that arises is ... How do I clear my memory... Call sqlite3_finalize() on every point

Re: [sqlite] TRANSACTION-question

transaction is finished I want it to continue. At 10:26 3/12/2004, you wrote: Yes, you do it. Bye   - Original Message -   From: Steven Van Ingelgem   To: [EMAIL PROTECTED]   Sent: Friday, December 03, 2004 10:02 AM   Subject: Re: [sqlite] TRANSACTION-question   Do you automatically end

Re: [sqlite] TRANSACTION-question

al Message -   From: Steven Van Ingelgem   To: [EMAIL PROTECTED]   Sent: Friday, December 03, 2004 8:51 AM   Subject: [sqlite] TRANSACTION-question   Hi,   I do the following (SQLite 308 from C++ source in windows):   BEGIN DEFERRED TRANSACTION;DELETE FROM Inbox;INSERT...;COMMIT TRANSACTION; END T

[sqlite] Clearing of memory

Hi, Another question that arises is ... How do I clear my memory... I try to close a database with a query (transaction: cfr previous mail) prepared & database opened: Is it enough to do "sqlite3_finalize" (which is not when for example you are in a transaction -> memory ain't cleared). Is it

[sqlite] TRANSACTION-question

Hi, I do the following (SQLite 308 from C++ source in windows): BEGIN DEFERRED TRANSACTION;DELETE FROM Inbox;INSERT...;COMMIT TRANSACTION; END TRANSACTION; Now, nothing is done? Nothing inserted, nothing deleted from Inbox... Then I tried to execute the same afterwards, but then I got that I am

[sqlite] Flush to disc

How can I make sure after an insert that everything has been flushed to disc? I mean, I want even my program to become slower as long as I know everything have been written to disc. At the moment I am using: PRAGMA default_synchronous = FULL; PRAGMA synchronous = FULL; And the queries are all

Re: [sqlite] Formatting SQLite-query

those parameters... And this project has been put aside for a while until I find a solution for this problem (it's the only thing keeping me from completing the program :p). But I have still other things to do ;-). Thanks for any help! At 21:35 1/11/2004, you wrote: Steven Van Ingelgem said

Re: [sqlite] Formatting SQLite-query

r but I am unable to determine the exact source... At 20:07 1/11/2004, you wrote: Steven Van Ingelgem said: > Sorry to bump this up, but i  was still not able to find an answer for > this > question :( > > http://www.wxwidgets.org/manuals/2.4.2/wx368.htm#wxstringformat Clay Dowling -- L

Re: [sqlite] Formatting SQLite-query

On Mon, 25 Oct 2004 20:43:31 +0200, Steven Van Ingelgem <[EMAIL PROTECTED]> wrote: >  Hi, > >  I wanted to create my own "Format"-thingie, based upon my own database: > > 

Re: [sqlite] Formatting SQLite-query

I am using Visual C++ 6. And I am using the source-version 3.0.8 of SQLite. So the va_list/end/start... functions should all be the very same... That's why it got me puzzled :S At 22:24 25/10/2004, you wrote: Hi Steve, > Hi, > > I wanted to create my own "Format"-thingie, based upon my own

[sqlite] Formatting SQLite-query

Hi, I wanted to create my own "Format"-thingie, based upon my own database: - Source - wxString SQLite3_Db::Format( const wxString& format, ... ) {   va_list marker;   va_start(marker,

[sqlite] Warnings during compilation

Hi, I just downloaded the sqlite sources (pre-build for windows & 3.0.8). Now during compilation I get this: 0 error(s), 539 warning(s) Is this normal? wxWidgets: CVS_HEAD OS:    WindowsXP/1 IDE:   MS Visual 6/5 pgppzHFOtJPY2.pgp Description: PGP signature

Re: [sqlite] sqlite.exe binary (windows)

True ... After thinking a while I understood it ;-) Thanks for the explanation. Steven At 16:16 9/09/2004, you wrote: On Thu, 9 Sep 2004, Steven Van Ingelgem wrote: >I just noticed something rather stupid... > >when you .dump a table via the sqlite.exe binary (2.8.15)... It du

[sqlite] sqlite.exe binary (windows)

I just noticed something rather stupid... when you .dump a table via the sqlite.exe binary (2.8.15)... It dumps first the "create table", then the "insert"s, and afterwards the indexes Now if you have a very big table it will take a LOT of time to place those indexes... Maybe it is more

Re: [sqlite] Upgrading SQLite versions

are on windows server... 1 person opens the program on 1 client, 2nd person on 2nd client, 2nd tries to insert an adress... Both setups give 'database is locked'. :S Sorry for the long delay (no internet for 4 days -> arrgh). At 10:15 20/08/2004, you wrote: Steven Van Ingelgem wrote: Hi, 1

[sqlite] Upgrading SQLite versions

Hi, 1/ I am currently using 2.8.13 and I wanted to upgrade it to 2.8.15... Now when I do that, my program crashes when I try to open (sqlite_open) the database on the following function:   rc = sqliteBtreeFactory(db, zFilename, 0, MAX_PAGES, >aDb[0].pBt); Is that "normal" behaviour (for

Re: [sqlite] SQLite for Win32 TCHAR

I understand what he means... I am using SQLite 2.8.11 and I did notice this too... Some Win32 fucntions should have 'A' attached to the end. This way it does not complain when using SQLite embedded in a UNICODE project. [ I even think I submitted a diff with things you would have to change to

[sqlite] Transaction -> OE_Ignore

How do I set a transaction (inserting items) to ignore doubles in keys? As the default behaviour now is to abort/rollback... I've also been looking where the sqlite_vm - structure is defined, but I did not found anything... Is that normal? Or is it just a pointer to a struct with nothing

[sqlite] Constraint violation on INSERT/UPDATE

I submitted a file to my database, where I just put some unique's on... Now I had a double there somewhere ... And now the whole transmission is not submitted... So I went looking into the sqlite source... And I figured out I should use OE_Ignore (first of all, is that correct if I just want

[sqlite] UTF8 question

If I have a table like: CREATE TABLE routing ( FIELD1 VARCHAR(40) ); what if I get a string which is in ANSI = 40chars, but in UTF8 > 40chars? (for example because it uses ü and such characters...) Does it get stored correctly? G00fy, (aka KaReL, aka Steven) Main Webpage :