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

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: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/' >

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

[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

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

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 (( UNION ) INTERSECT ( UNION > )) WHERE X= > > Each of the select a through d statements all return the same column x. If I > remove the inner parentheses, it executes just

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

[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] 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

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

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

[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] 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 wrote: > I used the Solid database for many years, since they came

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

On Wed, Mar 11, 2009 at 9:14 AM, Hynes, Tom 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');

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] LEFT INNER JOIN a second database

On Wed, 11 Mar 2009 06:12:37 -0700 (PDT), 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

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] 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

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 "." >

Re: [sqlite] LEFT INNER JOIN a second database

On Wed, Mar 11, 2009 at 8: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

[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

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] 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

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

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] get_table and bind

Citando Igor Tandetnik : > 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] "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:

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

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. >

[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] 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

[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