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
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
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
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 lines){
On Mon, Jun 20, 2011 at 6:55 AM, Ryan Johnson ryanj...@ece.cmu.edu 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 SQLite
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
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
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
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_BUSY, but I
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 busy-waiting to
On 20/06/2011 6:59 AM, Richard Hipp wrote:
On Mon, Jun 20, 2011 at 6:55 AM, Ryan Johnsonryanj...@ece.cmu.edu 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
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 =
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 before
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
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
On Mon, Jun 20, 2011 at 4:11 PM, HFN Account hfn1...@yahoo.com 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.org
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
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 fine if
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
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 *
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
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
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,
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
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:
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-
From:
26 matches
Mail list logo