[sqlite] Re: v2 and v3 differences - Help with some SQL

2007-07-04 Thread Igor Tandetnik
Dr Gerard Hammond wrote: This SQL in a sqlite v2 database gives me 306 rows... This is what I would expect. SELECT date_trans, t.description, c.CategoryAbsolutePath, GST, total, TransID, HasSplitTrans, t.categoryID, t.Currency, t.locked FROM Transn t left outer join Category c on

[sqlite] v2 and v3 differences - Help with some SQL

2007-07-04 Thread Dr Gerard Hammond
Hi, This SQL in a sqlite v2 database gives me 306 rows... This is what I would expect. SELECT date_trans, t.description, c.CategoryAbsolutePath, GST, total, TransID, HasSplitTrans, t.categoryID, t.Currency, t.locked FROM Transn t left outer join Category c on c.CategoryID=t.categoryID

RE: [sqlite] attached databases

2007-07-04 Thread Samuel R. Neff
Use UNION to run queries against each db and return a single result. HTH, Sam --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED]

Re: [sqlite] SQLite 64-Bit

2007-07-04 Thread Robert L. Cochran
Of course, you also need a 64-bit capable processor. I've been compiling SQLite on AMD Athlon 64 boxes using Fedora Core and CentOS x86_64 operating systems (and that means the gcc toolchain) for ages. Bob Cochran > -Original Message- > From: Ahmed Sulaiman [mailto:[EMAIL PROTECTED] >

RE: [sqlite] SQLite 64-Bit

2007-07-04 Thread Ahmed Sulaiman
Thanks Ian,.. I will give it a try :) -Original Message- From: Ian Frosst [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 04, 2007 3:26 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite 64-Bit I build SQLite's code using Visual Studio 2005 using the 64 bit tool chain, and it

Re: [sqlite] SQLite 64-Bit

2007-07-04 Thread Ian Frosst
I build SQLite's code using Visual Studio 2005 using the 64 bit tool chain, and it runs without a hitch. I haven't seen a pre-compiled library for it, so you may have to get your hands a bit dirty. Building it is a snap though; add the sqlite3.c and sqlite3.h files to a project, define NO_TCL

[sqlite] SQLite 64-Bit

2007-07-04 Thread Ahmed Sulaiman
Hi all, We are interested in using the SQLite in our project. I wonder if there a version that works in 64-Bit machine? I have looked in the download page and noticed that only Win32 (x86) builds are available. Regards Ahmed

Re: [sqlite] Database File size not exceeding 2GB

2007-07-04 Thread Andrew Finkenstadt
According to http://en.wikipedia.org/wiki/File_Allocation_Table , the limit on FAT16 is 2 gigabytes per file, on FAT32 it's 4 gigabytes per file, and on NTFS it's very, very large. In my application I needed to deal with splitting my data into 2 gigabyte (maximum) database file sizes, and I had

Re: [sqlite] Re: sqlite_finalize() releases resources?

2007-07-04 Thread Mario Figueiredo
On 7/4/07, Dan Kennedy <[EMAIL PROTECTED]> wrote: On Wed, 2007-07-04 at 09:58 +0200, Jef Driesen wrote: > Igor Tandetnik wrote: > > Mario Figueiredo wrote: > >> I'm a tad bit confused with sqlite3_finalize() usage when the query > >> fails. As it is, I'm assuming it releases resources and I use

[sqlite] Re: sqlite_finalize() releases resources?

2007-07-04 Thread Jef Driesen
Dan Kennedy wrote: On Wed, 2007-07-04 at 09:58 +0200, Jef Driesen wrote: Igor Tandetnik wrote: Mario Figueiredo wrote: I'm a tad bit confused with sqlite3_finalize() usage when the query fails. As it is, I'm assuming it releases resources and I use it in this context:

Re: [sqlite] Database File size not exceeding 2GB

2007-07-04 Thread Ian Frosst
Is the file system holding your file Fat32, or NTFS? If it's Fat32, it may be the source of your problem, as it doesn't support very large files. Ian On 7/4/07, Krishnamoorthy, Priya (IE10) <[EMAIL PROTECTED]> wrote: Hi all, I am using SQLite3 database in my application. My application

[sqlite] attached databases

2007-07-04 Thread Tom Deblauwe
Hello, As I understand it, you can attach databases together with sqlite and then perform 1 query on all the databases together. I have this situation where I have 3 disks, and every disk contains a database, and each of those databases has the same structure: ID, TimeFrom, TimeTo, Events

[sqlite] self join instead of temporary table

2007-07-04 Thread Jeffrey Ratcliffe
The following query works fine (and is quick), but I can't help thinking that it should be possible to it with a single SELECT and a self join. CREATE TEMPORARY TABLE temp (eid INT, P DOUBLE); INSERT INTO temp (eid, P) SELECT eid, MIN(P) FROM barforce_1 GROUP BY eid; SELECT a1.eid, a1.P,

Re: [sqlite] Re: sqlite_finalize() releases resources?

2007-07-04 Thread Dan Kennedy
On Wed, 2007-07-04 at 09:58 +0200, Jef Driesen wrote: > Igor Tandetnik wrote: > > Mario Figueiredo wrote: > >> I'm a tad bit confused with sqlite3_finalize() usage when the query > >> fails. As it is, I'm assuming it releases resources and I use it in > >> this context: > >> > >>

[sqlite] Re: sqlite_finalize() releases resources?

2007-07-04 Thread Jef Driesen
Igor Tandetnik wrote: Mario Figueiredo wrote: I'm a tad bit confused with sqlite3_finalize() usage when the query fails. As it is, I'm assuming it releases resources and I use it in this context: rc = sqlite3_prepare_v2(/* ... */); if (rc != SQLITE_OK) {