Re: [sqlite] Problem with System.Data.SQLite and join II

Alessandro, stop drinking, or at least dont ask support. may be incredible at your eyes but some times peoples is working,, ciao Il giorno mar, 21/06/2011 alle 00.27 +0200, Alessandro Caliaro ha scritto: > Thanks Simon. I'm happy not to be alone > Bye > > > -Messaggio originale- >

Re: [sqlite] Problem with System.Data.SQLite and join II

Thanks Simon. I'm happy not to be alone Bye -Messaggio originale- From: Simon Slavin Sent: Tuesday, June 21, 2011 12:25 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problem with System.Data.SQLite and join II On 20 Jun 2011, at 10:55pm, Alessandro Caliaro wrote:

Re: [sqlite] Problem with System.Data.SQLite and join II

On 20 Jun 2011, at 10:55pm, Alessandro Caliaro wrote: > Thanks to all. I've found the problem. I was working on two different db... > ;( Heh. We've all made mistakes like that. Glad you caught it. Simon. ___ sqlite-users mailing list

Re: [sqlite] Problem with System.Data.SQLite and join II

Thanks to all. I've found the problem. I was working on two different db... ;( Ale -Messaggio originale- From: Simon Slavin Sent: Monday, June 20, 2011 11:12 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problem with System.Data.SQLite and join II On 20 Jun 2011,

Re: [sqlite] Problem with System.Data.SQLite and join II

Integrity is ok. I've downloaded the installation package from http://sqlite.phxsoftware.com/ I think the SQLite version is 3.6.16 Ale -Messaggio originale- From: Simon Slavin Sent: Monday, June 20, 2011 11:12 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problem

Re: [sqlite] Problem with System.Data.SQLite and join II

On 20 Jun 2011, at 10:05pm, Alessandro Caliaro wrote: > Your test works fine. I have returned all lines... > Which could be the problem? Then the data is actually there. Run an integrity check in the command-line shell: http://www.sqlite.org/pragma.html#pragma_integrity_check If this says

[sqlite] Documentation typos and inconsistent logic

1. May be added note "All triggers associated with the view are also deleted." to http://www.sqlite.org/lang_dropview.html 2. This behaviour is incompatible with other DBMS and undocumented: sqlite> create table a(a); sqlite> create view b as select * from a; sqlite> drop table a; sqlite> select

Re: [sqlite] Problem with System.Data.SQLite and join II

Hi Simon. Your test works fine. I have returned all lines... Which could be the problem? -Messaggio originale- From: Simon Slavin Sent: Monday, June 20, 2011 10:55 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Problem with System.Data.SQLite and join II On 20 Jun

Re: [sqlite] Problem with System.Data.SQLite and join II

On 20 Jun 2011, at 9:49pm, Alessandro Caliaro wrote: > SELECT DISTINCT COM_STRADARIO.ID_STRADARIO, COM_STRADARIO.TIPO_VIA, > COM_STRADARIO.NOME_VIA FROMCOM_STRADARIO inner join INT_CONDOMINI on > COM_STRADARIO.ID_STRADARIO = INT_CONDOMINI.ID_STRADARIO ORDER BY NOME_VIA > > It works

[sqlite] Problem with System.Data.SQLite and join II

Sorry if you have already received this post, but I don’t know if I’ve been able to send it. I'm using this wonderful library with no problem till today. I've this simple query SELECT DISTINCT COM_STRADARIO.ID_STRADARIO, COM_STRADARIO.TIPO_VIA, COM_STRADARIO.NOME_VIA FROMCOM_STRADARIO

Re: [sqlite] SQLite for 64-bit Windows-based machines?

On Mon, Jun 20, 2011 at 4:11 PM, HFN Account wrote: > Hello SQLite users, > > This is my first post to this user group, so please be gentle with me if I > am out of line. > > I would like to know if there is SQLite for 64-bit Windows-based machines. > On the web site of

[sqlite] SQLite for 64-bit Windows-based machines?

Hello SQLite users, This is my first post to this user group, so please be gentle with me if I am out of line. I would like to know if there is SQLite for 64-bit Windows-based machines. On the web site of SQLite.org there is version 3.7.6.3 for Widnows 32-bit. How about a version for 64-bit

Re: [sqlite] Sqlite database integrity check fails with disk I/O error (10)

If I had the same problem ... I would: 1. Refresh the surface of the hard drive using spinrite (grc.com), which is OS and file-structure independent; 2. Then, I'd run the Linux equivalent to the Windows chkdsk command to resolve any file-structure issues; In all but the worst hard drive

Re: [sqlite] Sqlite database integrity check fails with disk I/O error (10)

> Can some one help me why the disk I/O error occured during the > sqlite3_prepare()  statement ? Because while preparing the statement SQLite must read schema from the database. And although in case of integrity check it's not really necessary I think it's still the general rule and is done

[sqlite] Sqlite database integrity check fails with disk I/O error (10)

Hi I am using the Sqlite database in the linux box . Here I am encountered the disk I/O error when I perform the integrity check on the database. The error occuted during the sqlite prepare statement only. The prepared select statement is : " pragma integrity_check " retValue =

Re: [sqlite] Newbie question, how multiple joins are executed

On 20/06/2011 6:59 AM, Richard Hipp wrote: > On Mon, Jun 20, 2011 at 6:55 AM, Ryan Johnson wrote: >> IIRC sqlite does *not* do any join ordering optimizations and simply >> runs them in whatever order the query specifies. This can have >> unfortunate effects on runtime for

Re: [sqlite] SQLITE_CANTOPEN on an open database

Thanks Jay, that clears things up for me. On 20/06/2011 14:17, Jay A. Kreibich wrote: > On Mon, Jun 20, 2011 at 02:04:36PM +0100, Ian Hardingham scratched on the > wall: >> Hey guys. >> >> We revisit my situation - I'm accessing the same database with 4 >> processes and they are using

Re: [sqlite] SQLITE_CANTOPEN on an open database

On Mon, Jun 20, 2011 at 02:04:36PM +0100, Ian Hardingham scratched on the wall: > Hey guys. > > We revisit my situation - I'm accessing the same database with 4 > processes and they are using busy-waiting to access the db somewhat > concurrently. > > I'm expecting SQLITE_LOCKED and

[sqlite] SQLITE_CANTOPEN on an open database

Hey guys. We revisit my situation - I'm accessing the same database with 4 processes and they are using busy-waiting to access the db somewhat concurrently. I'm expecting SQLITE_LOCKED and SQLITE_BUSY, but I also get SQLITE_CANTOPEN - this is on an *already open* database and a query shortly

[sqlite] problem with join and System.Data.Sqlite

Hi. I'm using this wonderful library with no problem till today. I've this simple query SELECT DISTINCT COM_STRADARIO.ID_STRADARIO, COM_STRADARIO.TIPO_VIA, COM_STRADARIO.NOME_VIA FROMCOM_STRADARIO inner join INT_CONDOMINI on COM_STRADARIO.ID_STRADARIO = INT_CONDOMINI.ID_STRADARIO ORDER

[sqlite] Auto Reply: sqlite-users Digest, Vol 42, Issue 20

This is an auto-replied message. I am currently unavailable. I will be back at work on Tuesday 28th June. For urgent questions please contact Michael Brey (michael.b...@oracle.com) ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Newbie question, how multiple joins are executed

On Mon, Jun 20, 2011 at 6:55 AM, Ryan Johnson wrote: > IIRC sqlite does *not* do any join ordering optimizations and simply > runs them in whatever order the query specifies. This can have > unfortunate effects on runtime for some queries. Can anyone verify this? > > The

Re: [sqlite] Newbie question, how multiple joins are executed

On 19/06/2011 8:03 PM, Simon Slavin wrote: > On 20 Jun 2011, at 12:58am, Lucas Cotta wrote: > >> I understand that for a query with a two tables join, SQLite will do a >> nested loop join with these two tables. >> But what about a query joining 5 tables? >> It would be like this?: >> >> for(table1

Re: [sqlite] Garbled data after binding

On 20 Jun 2011, at 9:23am, Jean-Denis Muys wrote: > Select * is not very informative, though we can try to guess. Please select > only the mentioned columns. Check to see they don't have any unexpected 'invisible' characters in, by doing something like SELECT FullName,LENGTH(FullName) FROM

Re: [sqlite] Garbled data after binding

On 20 juin 2011, at 08:42, CodeBoy DVM wrote: > NSEnumerator *enumerator = [ward objectEnumerator]; > id element; > > while(element = [enumerator nextObject]) > { You might want to modernize that code a bit (though this is likely not your problem here): for

[sqlite] Garbled data after binding

Greetings: I recently upgraded to a MacBook Pro with an i7 processor. The current version of sqlite on this machine is 3.6.12. For the last 4+ years, I have been using a MacBook Intel Core Duo. I am not a trained professional programmer, I do it for fun and to have some personal