RE: [sqlite] Newbie's first question about using SQLite in C++

> -Original Message- > From: EzTools Support [mailto:[EMAIL PROTECTED] > Sent: 11 September 2004 00:30 > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Newbie's first question about using > SQLite in C++ > > I would use the SqlitePlus COM DLL with .NET rather than try > to wrap it with

[sqlite] Mozilla XPCOM

Hi, I'm using my own little sqlite-based program to manage my personal information chaos. It needs some browser interaction so it's making me smiling brightly, when thinking on the things I could do porting this to the mozilla-platform. Unfortunately this mozilla-thing still lacks an easy-to-use

[sqlite] Question about sqlite3_finalize()

Hello, Is it safe to call sqlite3_finalize() even if sqlite3_prepare() has returned an error? Or should I call sqlite3_finalize() only when sqlite3_prepare() has returned SQLITE_OK? TIA, -- Tito

Re: [sqlite] Question about sqlite3_finalize()

sqlite3_prepare only gives a valid sqlite3_stmt if everything goes ok so you shouldn't call finalize if an error occurs. On Mon, 13 Sep 2004 13:11:44 +0200, Tito Ciuro <[EMAIL PROTECTED]> wrote: > Hello, > > Is it safe to call sqlite3_finalize() even if sqlite3_prepare() has > returned an

Re: [sqlite] New DBD::SQLite*s

Le ven 10/09/2004 à 17:51, Matt Sergeant a écrit : > Uploaded to CPAN are DBD::SQLite 1.05 and DBD::SQLite2 0.33 > > Changes for DBD::SQLite2: > >0.33 > - Set HAVE_USLEEP appropriately. This massively improves >concurrent access to your SQLite DB. Grand. Could you solve the

Re: [sqlite] Re: my own fixes for symbol conflict - encode.c

Matt Sergeant wrote: I don't think encode.c is part of sqlite3 - it certainly isn't relevant now sqlite has proper blob support. encode.c has now been removed from the version 3.0 source tree. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565

[sqlite] sqlite output request: .mode csv

I have been asked to output an 'Excel'-friendly report for someone, which means dumping a "CSV" (Comma Separated Values) file. Setting ".separator ',' " gets me part of the way. Unfortunately, I need to manually quote strings using something like this: SELECT '"' || name || '"', '"' || address

Re: [sqlite] Mozilla XPCOM

On Mon, Sep 13, 2004 at 11:53:05AM +0200, Stefan Neumann wrote: > me smiling brightly, when thinking on the things I could do porting this > to the mozilla-platform. The mozilla SQL stuff is here: http://eu.mozdev.org/Brussels2003/talks/jan/index.html I thought of just using the sqlite command

[sqlite] Default column value as current date

Is there any way to make the default column value as the current datetime? Thanks! Bob

Re: [sqlite] Mozilla XPCOM

On Mon, 13 Sep 2004, Stefan Neumann wrote: >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? My company

[sqlite] Java Wrapper for SQLite3

Hello, is there a stable and tested java (1.5) wrapper for sqlite3 out? Very best regards -- ### # # alex-t.de # Softwareentwicklung & Webentwicklung # Alex Tugarev # -- # mobil: (+49 179) 909 379 2 # privat:

Re: [sqlite] sqlite output request: .mode csv

On Mon, September 13, 2004 8:28, Ron Aaron said: > I have been asked to output an 'Excel'-friendly report for someone, which > means dumping a "CSV" (Comma Separated Values) file. > > Setting ".separator ',' " gets me part of the way. Unfortunately, I need to > manually quote strings using

Re: [sqlite] Mozilla XPCOM

Howdy, On Mon, 13 Sep 2004 19:48:25 +0100 (BST), Christian Smith <[EMAIL PROTECTED]> wrote: > On Mon, 13 Sep 2004, Stefan Neumann wrote: > >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

[sqlite] PATCH: [sqlite] sqlite output request: .mode csv

On Mon, September 13, 2004 12:14, Ron Aaron said: Responding to my own complaint: here is a patch against current CVS version, fixing the typo in the '-help' and implementing ".mode cvs" properly (at least, in my opinion) -- My GPG public key is at http://ronware.org/ fingerprint: 8130 734C

[sqlite] Question on selecting rows of an arbitrary range

Hi there! In order to select a number of files that have about a certain size in sum, I tried to throw this query: select id, type, filename, filesize from diskcache_index a where (select sum(filesize) from diskcache_index b where a.id < b.id) < MYCLEANSIZE I'm doing this to find out a certain

Re: [sqlite] New DBD::SQLite*s

On Fri, 10 Sep 2004, David Morel wrote: > Le ven 10/09/2004 à 17:51, Matt Sergeant a écrit : > > Uploaded to CPAN are DBD::SQLite 1.05 and DBD::SQLite2 0.33 > > > > Changes for DBD::SQLite2: > > > >0.33 > > - Set HAVE_USLEEP appropriately. This massively improves > >concurrent

[sqlite] Question on selecting rows of an arbitrary range

Return Receipt Your [sqlite] Question on selecting rows of an arbitrary range document :

[sqlite] more fine-grained SQL error codes?

Is there a way to get more fine-grained error information from SQLite in the case of a SQL error, other than the error message? I'm thinking of the particular case of a table already existing that you try to CREATE TABLE on -- right now, you just get SQLITE_ERROR and the actual error is in the

[sqlite] Question on selecting rows of an arbitrary range

Return Receipt Your [sqlite] Question on selecting rows of an arbitrary range document :