RE: [sqlite] How to compile without TCL on Vs.Net

2004-09-16 Thread Ned Batchelder
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

Re: [sqlite] How to compile without TCL on Vs.Net

2004-09-16 Thread Darren Duncan
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

Re: [sqlite] [SOLVED] Re: [sqlite] nfs 'sillynames'

2004-09-16 Thread Ara.T.Howard
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: [sqlite] [SOLVED] Re: [sqlite] nfs 'sillynames'

2004-09-16 Thread Derrell . Lipman
"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

[sqlite] [SOLVED] Re: [sqlite] nfs 'sillynames'

2004-09-16 Thread Ara.T.Howard
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

[sqlite] How to compile without TCL on Vs.Net

2004-09-16 Thread Sören Krings
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

Re[2]: [sqlite] I need a SQLite3 Wrapper for Java.

2004-09-16 Thread Sören Krings
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

Re: [sqlite] counting distinctly

2004-09-16 Thread Darren Duncan
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

Re: [sqlite] Shadow Pager

2004-09-16 Thread Doug Currie
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

Re: [sqlite] SQLITE_ERROR instead of SQLITE_FULL

2004-09-16 Thread Kurt Welgehausen
Your disk is full; the database is not full. Regards

Re: [sqlite] I need a SQLite3 Wrapper for Java.

2004-09-16 Thread Kurt Welgehausen
> I wish to get the count of unique entries in a particular field http://www.sqlite.org/omitted.html

[sqlite] SQLITE_ERROR instead of SQLITE_FULL

2004-09-16 Thread George Ionescu
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

[sqlite] size of the cache

2004-09-16 Thread Jérôme VERITE
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 it’s the use of the cache which permits such performances. S How can I

RE: [sqlite] counting distinctly

2004-09-16 Thread Downey, Shawn
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

Re: [sqlite] question on speed - or what am I doing wrong

2004-09-16 Thread Tito Ciuro
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

Re: [sqlite] question on speed - or what am I doing wrong

2004-09-16 Thread Derrell . Lipman
<[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

Re: [sqlite] question on speed - or what am I doing wrong

2004-09-16 Thread Bert Verhees
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

RE: [sqlite] I need a SQLite3 Wrapper for Java.

2004-09-16 Thread Downey, Shawn
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

[sqlite] question on speed - or what am I doing wrong

2004-09-16 Thread borislav
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,

[sqlite] Mozilla XPCOM

2004-09-16 Thread Valia V. Vaneeva
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

Re: [sqlite] I need a SQLite3 Wrapper for Java.

2004-09-16 Thread [EMAIL PROTECTED]
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?

Re: [sqlite] I need a SQLite3 Wrapper for Java.

2004-09-16 Thread Randy J. Ray
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 --

Re: [sqlite] I need a SQLite3 Wrapper for Java.

2004-09-16 Thread Cory Nelson
I take it you were too lazy to look at the SQLite Wrappers section? http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers On Thu, 16 Sep 2004 08:23:42 +0200, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello, > > Is there a SQLite3 Wrapper for Java available? Didn't find one. Please > help me.

[sqlite] I need a SQLite3 Wrapper for Java.

2004-09-16 Thread [EMAIL PROTECTED]
Hello, Is there a SQLite3 Wrapper for Java available? Didn't find one. Please help me. Very best regards -- ### # # alex-t.de # Softwareentwicklung & Webentwicklung # Alex Tugarev # -- # mobil: (+49 179) 909