Re: [sqlite] Multiple inner join confusion

2004-04-12 Thread Rob Duncan
Thanks to Richard for responding—I will do as he suggests. I am still curious about the cause of the error, though. After sleeping on it my hypothesis is that the temporary table generated by the first of my inner joins has columns with names "aa.i" and "aa.j", so the using clause of the

RE: [sqlite] Multiple inner join confusion

2004-04-12 Thread Cronos
I am also having difficulty getting to grips with the (awkward) join notation. In 3.0 how about support for Oracle type joins with (+) which seems far simpler to me :) -Original Message- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: 12 April 2004 13:00 Cc: [EMAIL PROTECTED]

Re: [sqlite] PRAGMA empty_result_callbacks

2004-04-12 Thread Aaron Patterson
aducom wrote: We thought that this was a problem too, but investigating we found out that in version 12 the execution of the pragma did not trigger the callback, but version 13 does. Which means that you have to ignore this first trigger, since it contains no data. Albert Drent aducom

[sqlite] PRAGMA empty_result_callbacks

2004-04-12 Thread Aaron Patterson
Hi, I just upgraded from 2.8.12 to 2.8.13 via RPM. I was wondering if anyone else noticed that PRAGMA empty_result_callbacks seems to break stuff now. Whenever I execute a statement with that pragma, my callback function can't get any column name information. Do I need to update my code for

[sqlite] Using SQLite with WIN32 (VB6) with Oledb (No odbc)

2004-04-12 Thread ISA Programmi
Hallo, is it possible to integrate a SQLite db in a VB6 program, without using ODBC, but working with OLEDB (faster)? Thank you, Giuliano - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [sqlite] A proposal for SQLite version 3.0

2004-04-12 Thread Mark D. Anderson
Echoing some others' responses, particularly Darren's: 1. I don't see the rationale for putting much priority on multiple string encodings. After all, blobs still can't be stored natively :). UTF-16 adds extra complexity, because of embedded nulls, and because of its own need for a

Re: [sqlite] long filenames on Mac OS

2004-04-12 Thread James W. Walker
Will Leshner <[EMAIL PROTECTED]> wrote: My guess is that very few people care about this problem, but on the "Classic" versions of Mac OS (basically 8 and 9), you can't have file names longer than 31 characters. This becomes a problem when you have a database file name that is very long, but not

RE: [sqlite] long filenames on Mac OS

2004-04-12 Thread Bernie Cosell
On 12 Apr 2004 at 11:56, Williams, Kenneth (Ken) (TLR Corp) wrote: > > -Original Message- > > From: Ralph Wetzel [mailto:[EMAIL PROTECTED] > > As only sqlite needs to know, how a journal is named, how about always > > truncating the original filename so that it fits (with the > >

RE: [sqlite] long filenames on Mac OS

2004-04-12 Thread Williams, Kenneth (Ken) (TLR Corp)
> -Original Message- > From: Ralph Wetzel [mailto:[EMAIL PROTECTED] > Sent: Monday, April 12, 2004 11:52 AM > To: Will Leshner > Cc: Forum SQLite > Subject: Re: [sqlite] long filenames on Mac OS > > > Hi! > > Just my 5 ct: > > As only sqlite needs to know, how a journal is named, how

Re: [sqlite] long filenames on Mac OS

2004-04-12 Thread Ralph Wetzel
Hi! Just my 5 ct: As only sqlite needs to know, how a journal is named, how about always truncating the original filename so that it fits (with the concetanated -j* ) into whatever length is ok for all supported systems? Greetings, R. Wetzel - Original Message - From: "Will Leshner"

[sqlite] long filenames on Mac OS

2004-04-12 Thread Will Leshner
My guess is that very few people care about this problem, but on the "Classic" versions of Mac OS (basically 8 and 9), you can't have file names longer than 31 characters. This becomes a problem when you have a database file name that is very long, but not longer than 31 characters. When you

Re: [sqlite] user id select

2004-04-12 Thread Lloyd thomas
Thanks Ken, You make it look so simple. Lloyd - Original Message - From: "Williams, Kenneth (Ken) (TLR Corp)" <[EMAIL PROTECTED]> To: "Lloyd thomas" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, April 12, 2004 3:50 PM Subject: RE: [sqlite] user id select >

RE: [sqlite] user id select

2004-04-12 Thread Williams, Kenneth (Ken) (TLR Corp)
> -Original Message- > From: Lloyd thomas [mailto:[EMAIL PROTECTED] > Sent: Sunday, April 11, 2004 1:18 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] user id select > > > I am trying to create a query which selects a user where it > is not part of a > specified group. Perhaps you

Re: [sqlite] Multiple inner join confusion

2004-04-12 Thread D. Richard Hipp
Rob Duncan wrote: I'm a novice SQL user, and I'm confused by an apparently arbitrary limitation on multiple inner joins. select * from aa inner join bb using (i) inner join cc using (j); SQL error: cannot join using column j - column not present in both tables I suggest you work around the