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
> -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
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
>
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
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"
> -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
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
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
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
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
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
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]
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
13 matches
Mail list logo