Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 14 May 2007 23:10:37 +0200
From:      =?ISO-8859-2?Q?Jaros=B3aw_Staniek?= <js@iidea.pl>
To:        Drew Sanford <lauasanf@wilderness.homeip.net>
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:  <4648D04D.7000401@iidea.pl>
In-Reply-To: <4648ADB3.4010002@wilderness.homeip.net>
References:  <46465334.6020504@iidea.pl>	 <46472046.8000705@wilderness.homeip.net> <715841970705140552v7d6c5b6fgbee98cf256ad05e@mail.gmail.com> <4648AD91.1000301@iidea.pl> <4648ADB3.4010002@wilderness.homeip.net>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help
Drew Sanford said the following, On 2007-05-14 20:42:
> Jaros=B3aw 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=20
>>> everything in
>>> table1.
>>
>> SELECT * FROM table1 ORDER BY "key"
>>                                ^^^^
>>
>> A quick note: "key" is reservered word in sql and kexi cannot deal=20
>> with it yet properly by adding "" or by displayng appropriate warning.=

>>
>> Could you change the column name to something neutral and try again=20
>> and let me know?
>>
>=20
> Sorry. There's a new table called table11 in there with basically the=20
> same data.

There is _still_ a column called "key" in table11 you have sent me. Remov=
e the=20
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;

--=20
regards / pozdrawiam, Jaroslaw Staniek
  Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to wor=
k on
  Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org
  KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kd=
e.org




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