[sqlite] sqlite3 error in kexi-0.1beta5

I got this. kexi: btree.c:1043: sqlite3BtreeOpen: Assertion `sizeof(ptr)==sizeof(char*)' failed. KCrash: Application 'kexi' crashing... Can't figure out at this moment as I still work use 2.8.12 in production.

[sqlite] stepping with sqlite3_step() through search results and making changes

Hello, Is is safe to go row by row with sqlite3_step (after preparing a "SELECT" query) and make changes at the same time, like adding, deleting or modifying rows? Pretty much like nesting SQL commands. Will the next sqlite3_step point to some valid row if the row which would be returned by

Re: [sqlite] Large memory usage not freed?

On Nov 4, 2004, at 3:42 PM, D. Richard Hipp wrote: If we exit the process and then reopen the database in a new process, all that memory is not reallocated. Are you sure you have that right? What OS are you running? Also, how are you checking to see if the memory was deallocated in the first

Re: [sqlite] Large memory usage not freed?

Brett Granger wrote: If we exit the process and then reopen the database in a new process, all that memory is not reallocated. Are you sure you have that right? What OS are you running? -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

[sqlite] ANNOUNCE: SHSQL - SQL for LINUX/UNIX Shell scripts

Hi I have just released SHSQL under the GPL, it is a method how SQL can be easily intergrated into shell scripts. The web site is at http://www.edlsystems.com/shsql and can be downloaded from ftp://ftp.edlsystems.com/shsql (Needless to say a SQLite3 version is included) Enjoy Eddy -- Edward

[sqlite] Large memory usage not freed?

We are using sqlite on linux to create a database with several tables. Each of those tables contains tens of thousands of rows, so not excessively huge. In order to speed up the process, the entire set of inserts is wrapped in a BEGIN/COMMIT pair. This does dramatically improve the speed,

RE: [sqlite] transfer data from an MDB file to SQLite

Wow! Now takes about 5 seconds! Thanks! Luc -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: November 4, 2004 3:46 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] transfer data from an MDB file to SQLite Edovia Technologies said: > It works, although it takes

Re: [sqlite] transfer data from an MDB file to SQLite

Edovia Technologies said: > It works, although it takes quite a while to transfer data. Like about a > minute for 500 records! > > I'm sure there's a better way. Anyone knows? Wrap each table into a transaction. You'll be shocked at how much faster it is. I have a similar application to

[sqlite] transfer data from an MDB file to SQLite

Hi! So far, what I do is that I go through each record of a table in a MDB file and use sqlite3_exec( m_pDB, "INSERT INTO...", 0, 0, ); to transfer each record to my SQLite db. It works, although it takes quite a while to transfer data. Like about a minute for 500 records! I'm sure

Re: [sqlite] sqlite3_changes() != 0 after SELECT

Ben Summers wrote: Hi, I'm finding that in version 3, sqlite3_changes() != 0 after a SELECT query has been executed. What's the query? -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

Re: [sqlite] Question about UTF8 encoding in SQLite version 2.8.13

Liz Steel wrote: Sorry to keep on about this, but I raised a ticket on Tuesday (number 981) with severity and priority of 1 (since this is a major issue for my projet) and I haven't heard anything back yet. Even if it is not going to be fixed, I really need to know, as then we can take some

Re: [sqlite] Question about UTF8 encoding in SQLite version 2.8.13

Sorry to keep on about this, but I raised a ticket on Tuesday (number 981) with severity and priority of 1 (since this is a major issue for my projet) and I haven't heard anything back yet. Even if it is not going to be fixed, I really need to know, as then we can take some other action with

Re: [sqlite] Saving database

On Thu, Nov 04, 2004 at 04:24:50PM +0800, Ng Pheng Siong wrote: > On Thu, Nov 04, 2004 at 10:18:12AM +0200, [EMAIL PROTECTED] wrote: > > I've just started using Sqlite and still haven't figured out how to > > save the database to the disk. I can create a database and insert any > > data I

Re: [sqlite] Saving database

On Thu, Nov 04, 2004 at 10:18:12AM +0200, [EMAIL PROTECTED] wrote: > I've just started using Sqlite and still haven't figured out how to > save the database to the disk. I can create a database and insert any > data I want and select data from the table. But as soon as I leave the >

[sqlite] Saving database

Hello all, I've just started using Sqlite and still haven't figured out how to save the database to the disk. I can create a database and insert any data I want and select data from the table. But as soon as I leave the program all is gone. I've tried on both Win98 and WinXp with the same