Do you have SQLite Manager extension for Firefox installed? I had problems
with it having the database open until Firefox is restarted.
On Tue, Sep 14, 2010 at 15:45, Andrew Wood wrote:
> Im getting an error saying the database is locked even though no other
> process is accessing the file. I th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/14/2010 07:41 PM, Hemant Shah wrote:
> Sometimes I get following error:
>
> SQL logic error or missing database.
That text corresponds to the error code SQLITE_ERROR which is the code used
for a wide variety of error conditions that don't have
On 15 Sep 2010, at 3:41am, Hemant Shah wrote:
> I have written a C program that creates in-memory database. It reads packets
> from the network and insert some info in the database.
>
> Sometimes I get following error:
>
> SQL logic error or missing database.
Does the error occur only when s
Folks,
I have written a C program that creates in-memory database. It reads packets
from the network and insert some info in the database.
Sometimes I get following error:
SQL logic error or missing database.
I prepare statement, bind columns and run step.
After every insert I also delete ro
Hello,
Let say we create two tables:
create table a(num integer primary key);create unique index a_uq on a(num);
create table b(num integer primary key);create unique index b_uq on b(num);
Table a is populated with 1 million records and table b with 1000 records. We
run analyze and look at sqli
Did you by any chance introduced some unique constraint or unique
index on a set of columns one of which is primary key? AFAIK, there
was a problem in SQLite until some recent versions in processing of
redundant unique constraints in conjunction with natural joins.
But the best idea would be to po
On 15 Sep 2010, at 1:01am, JT Olds wrote:
> On this note, how does one figure out if your system does support
> atomic writes (or other FS things, like safe appends)?
>
> Is there an easy way to have SQLite tell you what it finds out?
Unfortunately, SQLite cannot tell if its underlying operatin
On this note, how does one figure out if your system does support
atomic writes (or other FS things, like safe appends)?
Is there an easy way to have SQLite tell you what it finds out?
Alternatively (for my current use case), does Ext3 on 2.6 Linux
support atomic writes or safe appends?
On Mon,
On 14-09-2010 23:50, Oliver Peters wrote:
> your version of sqlite?
I used several programs
SQLiteSpy,
SQLcc,
Python-programs,
so I don't know which versions of sqlite I used,
might that be the problem ?
> your OS?
windows XP
> your backend?
several, see above
> What exactly have you done before t
your version of sqlite?
your OS?
your backend?
What exactly have you done before the Natural Join stopped working?
Oliver
Am Dienstag, den 14.09.2010, 23:41 +0200 schrieb Stef Mientki:
> hello,
>
> after modifying some tables, natural join stopped working ???
>
> I've 2 tables, each with a
hello,
after modifying some tables, natural join stopped working ???
I've 2 tables, each with a field named "vlid", which is the primary key in one
of the tables
until a few moments ago, this worked perfectly
select Header from vraag
natural join vraaglist
where Nr = 0 and vraaglist.Name
if SQLITE is compiled with SQLITE_HAS_CODEC then the test 2.2 will fail, as
well as a number of the vacuum3 tests
recommend adding the follwing lines to the beginning of the file
# Do not use a codec for tests in this file, as the database file is
# manipulated directly using tcl scripts. See pr
if SQLITE is compiled with SQLITE_OMIT_LOOKASIDE then the dbstatus test 2 and
3 series will fail.
recommend adding the lines
ifcapable !lookaside {
finish_test
return
}
right before the lines
#---
# Run the dbstatus-2 an
>As far as I can tell, turning on foreign_keys for a database is not
>persistent. It only seems to be valid for that connection/session. So
>this means I have to prefix every command that I send to the database
>with a command to turn on foreign_keys and I therefore can't issue
>one-off comman
Hi all,
I've been playing around with:
pragma foreign_keys;
pragma foreign_keys = 1;
As far as I can tell, turning on foreign_keys for a database is not persistent.
It only seems to be valid for that connection/session. So this means I have to
prefix every command that I send to the database
On Tue, 14 Sep 2010, Jay A. Kreibich wrote:
> If that's a copy-paste from a default sqlite3 session, the single quotes
> are part of the value. i.e. you have four-character values, such as
> "'ID'".
Jay,
That's because I used single quotes to delimit strings in the original
.csv file. Re
On 14 Sep 2010, at 2:57pm, Jay A. Kreibich wrote:
> On Tue, Sep 14, 2010 at 06:52:02AM -0700, Rich Shepard scratched on the wall:
>> sqlite> select distinct state from Companies;
>> 'ID'
>> 'NV'
>> 'OR'
>> 'UT'
>> 'WA'
>
> If that's a copy-paste from a default sqlite3 session, the single
> qu
On 14 September 2010 14:52, Rich Shepard wrote:
> sqlite> select distinct state from Companies;
> 'ID'
> 'NV'
> 'OR'
> 'UT'
> 'WA'
It looks like the values in your db have quotes in them.
sqlite> create table companies(state char(2), name char(10));
sqlite> insert into companies values('OR','one
On Tue, Sep 14, 2010 at 06:52:02AM -0700, Rich Shepard scratched on the wall:
> On Tue, 14 Sep 2010, Paul Corke wrote:
>
> > What do you get from:
> >
> > select distinct state from companies;
>
> Paul,
>
> sqlite> select distinct state from Companies;
> 'ID'
> 'NV'
> 'OR'
> 'UT'
> 'WA'
If th
On Tue, Sep 14, 2010 at 06:45:24AM -0700, Rich Shepard scratched on the wall:
>I cannot select rows from a table using the WHERE clause and cannot find
> my error. Perhaps others will see what I miss.
>
>The table, Companies, has 1500+ rows. One column is defined as
>state CHAR(2),
On Tue, 14 Sep 2010, Paul Corke wrote:
> What do you get from:
>
> select distinct state from companies;
Paul,
sqlite> select distinct state from Companies;
'ID'
'NV'
'OR'
'UT'
'WA'
That's why this inability to use the WHERE clause completely escapes my
understanding.
Rich
_
On 14 September 2010 14:45, Rich Shepard wrote:
> sqlite> select * from Companies where state = 'OR';
What do you get from:
select distinct state from companies;
Paul.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bi
Im getting an error saying the database is locked even though no other
process is accessing the file. I think it was probably caused by a
process crashing part way through. Is there a way to force release the lock?
Andrew
___
sqlite-users mailing list
I cannot select rows from a table using the WHERE clause and cannot find
my error. Perhaps others will see what I miss.
The table, Companies, has 1500+ rows. One column is defined as
state CHAR(2),
but the select statement seeking all rows where state = 'OR' for example
returns nothi
Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 09/13/2010 04:06 PM, BareFeetWare wrote:
>> All this talk of replacing multiple commas with pipes, then replacing pipes
>> and so on, though clever and helpful is problematic, cumbersome and even
>> comical for a matur
doubled words
-
http://www.sqlite.org/lang_createtrigger.html
"occurs on on one or more specified columns of a table."
needless round bracket
--
http://www.sqlite.org/lang_conflict.html
"
(
IGNORE
"
Oliver
___
sqli
On 14 Sep 2010, at 9:55am, Nimish Nayak wrote:
> I was trying to figure out how to export the Database as an SQL File.
>
> I came across sqlite3_backup but it copies Db to Db. But i failed to get the
> Db to sql file as dont by SqliteBrowser
>
> I can achieve this using .dump or .bachup in sqli
I was trying to figure out how to export the Database as an SQL File.
I came across sqlite3_backup but it copies Db to Db. But i failed to get the
Db to sql file as dont by SqliteBrowser
I can achieve this using .dump or .bachup in sqlite cli but how should i do
it using the C API's ?
--
Mr. Ni
28 matches
Mail list logo
