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
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
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]
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]
>
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
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
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
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
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
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:
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
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
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,
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:
> >>
> >>
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)
{
15 matches
Mail list logo