Yes, you are right, I just tested it in another GUI myself. It is the GUI's
fault (SQLite Studio), which I found on the list on the SQLite site.
Damn, I would never have suspected the GUI. I would have thought that it
would just reroute whatever text I type in to the commandline...
They must have fucked up the original SQLite code or something... Anyway
that is a GUI that I will be dumping :)
Thanx alot for you help Igor!
Btw, what would be the best GUI to use?
/Rune Hjelm
----- Original Message -----
From: "Igor Tandetnik" <[EMAIL PROTECTED]>
To: "SQLite" <sqlite-users@sqlite.org>
Sent: Friday, November 23, 2007 6:22 PM
Subject: [sqlite] Re: A valid SQL fails with SQLite
[EMAIL PROTECTED] wrote:
As you can see, the same color (the last one, emissive) will be the
result for ALL colors. It seems as if your SQL-interpreter cannot handle
multiple definitions of the same table (aliased with AS) in the
FROM-clause?
Everything works correctly for me with sqlite3 command line utility, and
with SQLite Explorer. The problem must be in the visual tool you are using
(which looks quite half-baked, what with all the %s placeholders in the
UI).
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
