On Nov 23, 2007 11:47 AM, <[EMAIL PROTECTED]> wrote: > 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?
The command line. SQLite is now so heavily used and tested, and its developers are so incredibly good, that while nothing can be free of bugs 100%, SQLite is really, really careful, and very unlikely to have basic bugs like that you reported. > > > /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] > ----------------------------------------------------------------------------- > > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ Summer 2007 S&T Policy Fellow, The National Academies http://www.nas.edu/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
