[sqlite] Vacuum command is failing with SQL Error:Database or disk is full

Hi, I am trying to execute PRAGMA page_size=4096; Vacuum; on a SQLite DB(Size 1.5 GB), On a drive which has 9 GB free space (But my C: has 150 MB free is this an issue?). But it is failing with SQL Error:Database or disk is full error everytime. SQLite version: 3.6.11. 1) Am I missing anything

Re: [sqlite] compilation : undefined symbols.

On Mar 10, 2009, at 11:42 PM, Mayura S. wrote: Hello Sir, I downloaded sqlite 3.6.11 code for my project in my organisation. I'm not using the amalgamation code. I'm building the source code files in unix environment. I'm not new to sqlite, I have earlier worked on 3.2.2. My project

[sqlite] SQLState error codes from SQLite

Hi everyone, I am starting to use SQL but I can not seem to find any good documentation on the SQLStates. My little personal project is implemented in Java and I would like to handle the SQLExceptions correctly. To do that I have to interpret the SQLState, but all I found is somehow locked

Re: [sqlite] advice about opening an encrypted database

On Mar 10, 2009, at 8:31 PM, Dave Dyer wrote: using the standard sqlite encryption option: If I open a database I expect to be encrypted, and call sqlite_key to establish the expected key, how should I verify that the database is now open for business? Ie that the key was correct.

Re: [sqlite] Extract error text in C API

On Mar 10, 2009, at 10:07 PM, Andy wrote: I am using triggers to handle database integrity as suggested by the docs. When a violation occurs the 'SELECT RAISE(ROLLBACK, Blah)' is executed. I want to get extract the 'Blah' text using the C API but cannot seem to work out how to do

Re: [sqlite] Vacuum command is failing with SQL Error:Database or disk is full

manohar s wrote: Hi, I am trying to execute PRAGMA page_size=4096; Vacuum; on a SQLite DB(Size 1.5 GB), On a drive which has 9 GB free space (But my C: has 150 MB free is this an issue?). But it is failing with SQL Error:Database or disk is full error everytime. SQLite version: 3.6.11. 1)

Re: [sqlite] get_table and bind

Citando Igor Tandetnik itandet...@mvps.org: galea...@korg.it wrote: is it possible to use a similar function to get_table but starting by a statement in order to use the bind facilities? Anything wrong with calling sqlite3_step in a loop? Igor Tandetnik

Re: [sqlite] SQLite Transaction Rate and speed...

At 03:47am on 2009 March 08, VF did write: CREATE UNIQUE INDEX MAP_IDX_$idx ON MAPPINGS_$idx (key, mapping); CREATE INDEX KEY_IDX_$idx ON MAPPINGS_$idx(key); I am trying to do an upsert with the following logic: UPDATE MAPPINGS_$idx SET counter = counter + 1 , timeModified =

Re: [sqlite] Extract error text in C API

I did see that function and I had already tried that but it just gives me SQL logic error or missing database. The error code from the step command is 19 (constraint error). I t almost looks like a different error, but if I take out the triggers it works. Thanks Andy On Wed, Mar 11, 2009 at

[sqlite] insert in C

Good Morning, I would like to write in C the equivalent code for: insert into table1 values('Hello'); using a variable char temp[20]= Hello; instead of the literal Hello I have used multiple variations of the following, but no luck char temp[20]= Hello; sql = INSERT INTO probes

Re: [sqlite] insert in C

Hi, use sqlite3_prepare and sqlite3_bind. See http://www.sqlite.org/capi3ref.html#sqlite3_prepare and sqlite3_bind_text under http://www.sqlite.org/capi3ref.html#sqlite3_bind_blob const char* szTail=0; sqlite3_stmt* pVM; int nRet = sqlite3_prepare(mpDB, insert into table1 values(?),

[sqlite] LEFT INNER JOIN a second database

I have read and searched but I am not able to get the following statement to run: SELECT MyID, Zip FROM TableOne d LEFT OUTER JOIN DatabseTwo.sdb.TableTwo n ON n.MyID=d.MyID WHERE d.Zip 8 ORDER BY d.Zip I just get error at . I tried specifiying the databse name without the file extension

Re: [sqlite] LEFT INNER JOIN a second database

On Wed, Mar 11, 2009 at 8:12 AM, Derek Developer derekdevelo...@yahoo.com wrote: I have read and searched but I am not able to get the following statement to run: SELECT MyID, Zip FROM TableOne d LEFT OUTER JOIN DatabseTwo.sdb.TableTwo n ON n.MyID=d.MyID WHERE d.Zip 8 ORDER BY d.Zip I

Re: [sqlite] LEFT INNER JOIN a second database

On 12/03/2009 12:12 AM, Derek Developer wrote: I have read and searched but I am not able to get the following statement to run: SELECT MyID, Zip FROM TableOne d LEFT OUTER JOIN DatabseTwo.sdb.TableTwo n ON n.MyID=d.MyID WHERE d.Zip 8 ORDER BY d.Zip I just get error at . I tried

Re: [sqlite] insert in C

Hi Rajesh Nair, It works perfectly, Thank you, Michael If you want to use sqlite3_exec function then try this char *zSQL = sqlite3_mprintf(INSERT INTO probes VALUES(%Q), temp); sqlite3_exec(db, zSQL, 0, 0, 0); sqlite3_free(zSQL); This will format temp to hold any special chars which may

Re: [sqlite] tool to browse a sqlite database

This is now all sorted and it was indeed a simple bug in the wrapper. When parsing out the create table statement it hadn't anticipated the double quotes surrounding the tables and fields. I understand that this is in fact the standard/recommended way, although I don't do it myself and prefer:

Re: [sqlite] LEFT INNER JOIN a second database

On Wed, 11 Mar 2009 06:12:37 -0700 (PDT), Derek Developer derekdevelo...@yahoo.com wrote: I have read and searched but I am not able to get the following statement to run: SELECT MyID, Zip FROM TableOne d LEFT OUTER JOIN DatabseTwo.sdb.TableTwo n ON n.MyID=d.MyID WHERE d.Zip 8 ORDER BY

Re: [sqlite] SELECT queries and NULL value parameters

... yes, this is expected. Can you explain that a bit more? I certainly would not have expected it. Thanks. Tom -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Martin Engelschalk Sent: Wednesday, March 11, 2009 8:59 AM

Re: [sqlite] SELECT queries and NULL value parameters

On Wed, Mar 11, 2009 at 9:14 AM, Hynes, Tom tom.hy...@inin.com wrote: ... yes, this is expected. Can you explain that a bit more?  I certainly would not have expected it.   Thanks. sqlite CREATE TABLE foo (a); sqlite INSERT INTO foo VALUES (1); sqlite INSERT INTO foo VALUES ('ab'); sqlite

Re: [sqlite] SELECT queries and NULL value parameters

Thanks for the quick response! Yes, I understand the differences between querying with IS NULL vs. = NULL. But I had always thought that when using *parameter binding* a NULL query parameter would be treated like the IS NULL case when doing the comparison, not the equality case. Hmm, Sounds

Re: [sqlite] SELECT queries and NULL value parameters

you can also use ifnull(myvar1,'') = ifnull(myvar2,'') or something in the same way. I used it for avoiding creating 2 queries for each cases. Cheers, Sylvain On Wed, Mar 11, 2009 at 4:14 PM, Jim Wilcoxson pri...@gmail.com wrote: I used the Solid database for many years, since they came out

[sqlite] SQLITE : Constraint question

Hello, I am working on Database not for a long time. From SQLITE Tutorial exam table :* - Why is it possible to change data not defined in the constraint : Exemple : enter TEXT if the column is INTERGER ?? enter 25 caracters if column is declared VARCHAR(15) ?? I thought i will

Re: [sqlite] SQLITE : Constraint question

Hi, sqlite does not enforce datatypes. In this, sqlites works differently from other database engines. See http://www.sqlite.org/different.html and search for *Manifest typing The key sentence is *SQLite thus allows the user to store any value of any datatype into any column regardless of the

Re: [sqlite] Slow performance with Sum function

Do not be tempted by the incremental vacuum feature. Incremental vacuum will reduce the database size as content is deleted, but it will not reduce fragmentation. In fact, incremental vacuum will likely increase fragmentation. Incremental vacuum is just a variation on auto_vacuum.

Re: [sqlite] Slow performance with Sum function

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Trainor, Chris Sent: Wednesday, March 11, 2009 5:31 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Slow performance with Sum function Do not be tempted by

[sqlite] Proposal for SQLite and non pure ASCII letters

Hello group, I'd like to have the group opinion about a feature I would find utterly useful in _standard_ SQLite. Here's a rewrite of mails sent to hwaci about it, without success so far. Note: I guess that non pure ASCII characters in the sample strings below will translate to '?', but you

Re: [sqlite] Proposal for SQLite and non pure ASCII letters

Jean-Christophe Deschamps wrote: I'd like to have the group opinion about a feature I would find utterly useful in _standard_ SQLite. You are aware that standard SQLite is used in devices with a few kilobytes of memory through workstations and servers with gigabytes of it! As far as I can

Re: [sqlite] Nested SELECTS using UNION and INTERSECT syntax problems....

sorka wrote: I can't for the life of me figure this out. I'm trying to do a nested select like this: SELECT x FROM ((select a UNION select b) INTERSECT (select c UNION select d)) WHERE X=some value Each of the select a through d statements all return the same column x. If I remove the

Re: [sqlite] SQLITE : Constraint question

REPKA_Maxime_NeufBox wrote: - Why is it possible to change data not defined in the constraint : Exemple : enter TEXT if the column is INTERGER ?? enter 25 caracters if column is declared VARCHAR(15) ?? I thought i will get an error return See exemple below : As Martin

[sqlite] Proposal for SQLite and non pure ASCII letters

Roger, You are aware that standard SQLite is used in devices with a few kilobytes of memory through workstations and servers with gigabytes of it! That's precisely why such approach is interesting! As far as I can tell you want some extra standard collation sequences and propose shortcuts

Re: [sqlite] Proposal for SQLite and non pure ASCII letters

Roger Binns wrote: Jean-Christophe Deschamps wrote: I'd like to have the group opinion about a feature I would find utterly useful in _standard_ SQLite. You are aware that standard SQLite is used in devices with a few kilobytes of memory through workstations and servers with

Re: [sqlite] Query Doesn't Find Record

On Mar 12, 2009, at 12:01 AM, jonwood wrote: PaymentDate=2009/01/05 Note the '/'s And then I ran the following query: SELECT * FROM Payments WHERE FK_CustomerID=5 AND DATE(PaymentDate) = DATE('2009-01-01') AND DATE(PaymentDate) = DATE('2009-03-11') Note the '-'s. '2009/' '2009-' e

Re: [sqlite] Query Doesn't Find Record

Doug Currie-2 wrote: Note the '/'s What does this mean? What does DATE('2009-1-1') or DATE('2009/1/1') return? Does DATE() simply have no effect whatsoever? -- View this message in context: http://www.nabble.com/Query-Doesn%27t-Find-Record-tp22469520p22469578.html Sent from the SQLite

Re: [sqlite] Query Doesn't Find Record

On Mar 12, 2009, at 12:08 AM, jonwood wrote: Doug Currie-2 wrote: Note the '/'s What does this mean? What does DATE('2009-1-1') or DATE('2009/1/1') return? Does DATE() simply have no effect whatsoever? Sorry to be cryptic. sqlite select date('2009/12/03'); sqlite select