Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 14 May 2007 17:41:18 -0500
From:      Laurence Sanford <lauasanf@wilderness.homeip.net>
To:        =?ISO-8859-2?Q?Jaros=B3aw_Staniek?= <js@iidea.pl>
Cc:        Drew <cotharyus@gmail.com>, freebsd-questions@freebsd.org
Subject:   Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
Message-ID:  <4648E58E.5010908@wilderness.homeip.net>
In-Reply-To: <4648D04D.7000401@iidea.pl>
References:  <46465334.6020504@iidea.pl>		<46472046.8000705@wilderness.homeip.net>	<715841970705140552v7d6c5b6fgbee98cf256ad05e@mail.gmail.com>	<4648AD91.1000301@iidea.pl>	<4648ADB3.4010002@wilderness.homeip.net> <4648D04D.7000401@iidea.pl>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help
Jarosław Staniek wrote:
> Drew Sanford said the following, On 2007-05-14 20:42:
>> Jarosław Staniek wrote:
>>> Drew said the following, On 2007-05-14 14:52:
>>>> As promised, I'm attaching a database I just threw together. It 
>>>> only has
>>>> four entries, and one query, but clearly the query should list 
>>>> everything in
>>>> table1.
>>>
>>> SELECT * FROM table1 ORDER BY "key"
>>>                                ^^^^
>>>
>>> A quick note: "key" is reservered word in sql and kexi cannot deal 
>>> with it yet properly by adding "" or by displayng appropriate warning.
>>>
>>> Could you change the column name to something neutral and try again 
>>> and let me know?
>>>
>>
>> Sorry. There's a new table called table11 in there with basically the 
>> same data.
>
> There is _still_ a column called "key" in table11 you have sent me. 
> Remove the column and our query should work.
>
> Also queries that do not use the column work with table11, e.g.:
>
> SELECT vacation, users, date, vacation, id FROM table11 ORDER BY id;
>
I see where this is going. Actually, in the original db that I created, 
there is no conflict with "key" rather it appears to be start. However, 
I can specify that and get (correct) output from the queries. It looks 
like the problem is related specifically to using * in the select 
statement. Kexi keeps dropping the *.



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?4648E58E.5010908>