Kurt Welgehausen <[EMAIL PROTECTED]> writes:
>
> Your disk is full; the database is not full.
Hmm...
I really do not understand: it is true that my disk was full, but how can my database
be full? Isn't it supposed to expand as it needs?
And, regarding the error message I'm getting: don't you
You can quiet those warnings in the project properties.
In the project's property pages, under C/C++ - Advanced, there's a Disable
Specific Warnings field. I put in 4018;4090;4101;4133;4244;4267;4311;4312
and all those warnings are silenced.
--Ned.
http://nedbatchelder.com
-Original Message
At 8:32 AM +0930 9/17/04, Peter Loveday wrote:
how can i compile the sqlite3 source without any TCL bindings with
Visual Studio 7.1?
I simply left out 'tclsqlite.c' and 'shell.c', and the rest compiled
fine. You could probably define NO_TCL if you really want the source
file in there, but I just
how can i compile the sqlite3 source without any TCL bindings with
Visual Studio 7.1?
I simply left out 'tclsqlite.c' and 'shell.c', and the rest compiled fine.
You could probably define NO_TCL if you really want the source file in
there, but I just removed it.
And is ist normal that i get so mu
On Thu, 16 Sep 2004 [EMAIL PROTECTED] wrote:
If this were implemented, it would remove the capability to go into the
background. A common thing for a daemon process to do upon start-up is to
get everything initialized (e.g. open databases and do other things that
could fail and would need to be re
"Ara.T.Howard" <[EMAIL PROTECTED]> writes:
> the problem is that the child inherits all the open fds from the 'begin
> transaction' (sqlite db-journal, etc.). in my case, the child never uses
> these at all. regardless, when the parent does the unlink the sillyname is
> created.
>
> the child co
On Fri, 3 Sep 2004, John LeSueur wrote:
a followup on this post:
i was running some straces on sqlite while it using transactions and think
i
may have found the source of the problem, we see this in in the strace
output:
...
...
close(5)= 0
unlink("/dmsp/m
Sören Krings wrote:
[...] knows anyone a way to
write a platfrom independet Java wrapper which include the SQLitelib?
No, the JNI code will have to be recompiled for each platform, and
either statically or dynamically link to the SQLite library.
-- Gerhard
Hello,
how can i compile the sqlite3 source without any TCL bindings with
Visual Studio 7.1?
And is ist normal that i get so much conversion warnings?
Best Regards
Sören
Hello,
at the moment i´m writing a COM wrapper for SQLite3 which will work for
Visual basic and Delphi. For the future i´ve planed to write a SQLite3
wrapper for Java. But there is a basic design issu: How can i write
the wrapper platform independent? I know a way to use the SQlite API
from Java b
At 9:04 AM -0400 9/16/04, Downey, Shawn wrote:
Hello, I am new to sqlite and I wish to get the count of unique entries
in a particular field. The table is created as follows:
create table tablename
(
field_id char(10) not null ,
fieldname char(100)
);
create unique index findex on tabl
Wednesday, September 15, 2004, 9:36:00 PM, sankarshana rao wrote:
> Has anyone implemented the shadow pager for sqlite???
> Any info regarding this will be very helpful..
I began an implementation last winter, and set it aside once the
sqlite3 effort was announced. Presently I am busy with other
Your disk is full; the database is not full.
Regards
> I wish to get the count of unique entries in a particular field
http://www.sqlite.org/omitted.html
Hello sqlite users,
Hello dr. Hipp,
while working with sqlite and trying to insert large binary data into the database, I
got the error "SQL error or missing database". I thought it had become corrupted and I
ran a check on it. Everything ok. Then, I've noticed I had 6 Mbytes of free space on
C
Hi,
I want to optimize requests on a big database which works with sqlite
2.8.14. The first time I make a sql request, is spends 4 minutes before
returning a result, but the second time, it take only 2 seconds. I think
its the use of the cache which permits such performances. S
How can I modif
Thank you. That did it.
Shawn M. Downey
MPR Associates
632 Plank Road, Suite 110
Clifton Park, NY 12065
518-371-3983 x3 (work)
860-508-5015 (cell)
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 16, 2004 9:32 AM
To: [EMAIL PROTECTED]
Subject
That syntax does not seem to work for the sqlite version I am using
(2.8.0). I get the following:
Sqlite> select count(DISTINCT fieldname) from tablename;
SQL error: near "DISTINCT": syntax error
Is this a know limitation in 2.8.0? I am sort of stuck with this
version because it
Downey, Shawn wrote:
I wish to get the count of unique entries
SELECT count(*) FROM (SELECT DISTINCT column FROM table);
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
> Hello, I am new to sqlite and I wish to get the count of unique entries
> in a particular field. The table is created as follows:
> I get an error with the query:
> select (distinct fieldname) from tablename;
> but this gives me the wrong answer:
> select distinct (fieldname) from tablename;
On Sep 16, 2004, at 14:47, [EMAIL PROTECTED] wrote:
What do I have to do to make this faster? And reading? Please, give me
a
concrete answer with examples if possible...
http://www.sqlite.org/cvstrac/wiki?p=PerformanceConsiderations
-- Tito
The version of sqlite I am using is 2.8.0
Shawn M. Downey
MPR Associates
632 Plank Road, Suite 110
Clifton Park, NY 12065
518-371-3983 x3 (work)
860-508-5015 (cell)
-Original Message-
From: Downey, Shawn
Sent: Thursday, September 16, 2004 8:55 AM
To: [EMAIL PROTECTED]
Subject: RE: [sqli
<[EMAIL PROTECTED]> writes:
> Fact 3: I've done command ".read q.txt" which contains over 15900 of:
>
> insert into tmaster values(null,'01.01.2003','12:30','21.11.2004','Probna
> lokacija','232-k-212','Mico Micicevic','Stepe Stepanovica 17, 78000
> Prnjavor','Drasko Ignjatic','Mirko Miric','Bilja
use begin transaction, commit transaction
and do allinserts between those
Bert
Op donderdag 16 september 2004 14:47, schreef [EMAIL PROTECTED]:
> I'm having problems with sqlite query speed - in fact it is very slow
>
> Fact 1: I'm using sqlite 2.8.14
> Fact 2: my database file is named te2.d
Hello, I am new to sqlite and I wish to get the count of unique entries
in a particular field. The table is created as follows:
create table tablename
(
field_id char(10) not null ,
fieldname char(100)
);
create unique index findex on tablename
(field_id);
I get an error with th
I'm having problems with sqlite query speed - in fact it is very slow
Fact 1: I'm using sqlite 2.8.14
Fact 2: my database file is named te2.db - and has one it's layout looks
like this
create table tmaster (
broj integer primary key,
datumblok date,
vrijemeblok time,
datumdeblok date,
lokacija
Hi,
> I think sqlite could be ideal for this purpose. Does anybody know of
> any intentions to make something like an XPCOM-wrapper for sqlite?
> Could this mean a lot of work and is there any project that could
> serve as a starting-point?
You can look at http://www.mozilla.org/projects/sql and
h
Hello,
and yes I do. I've tried to port, but without success.
Best regards
Am Thu, 16 Sep 2004 00:31:54 -0700 hat Randy J. Ray <[EMAIL PROTECTED]>
geschrieben:
Cory Nelson wrote:
I take it you were too lazy to look at the SQLite Wrappers section?
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappe
Cory Nelson wrote:
I take it you were too lazy to look at the SQLite Wrappers section?
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
Perhaps he did, and looked closely enough to notice that both Java wrappers are
for SQLite 2.X only.
Randy
--
29 matches
Mail list logo