From owner-freebsd-questions@FreeBSD.ORG Mon May 14 18:41:12 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 1906916A400 for ; Mon, 14 May 2007 18:41:12 +0000 (UTC) (envelope-from js@iidea.pl) Received: from openoffice.home.net.pl (openoffice.home.net.pl [62.129.241.178]) by mx1.freebsd.org (Postfix) with ESMTP id CAD7013C44C for ; Mon, 14 May 2007 18:41:10 +0000 (UTC) (envelope-from js@iidea.pl) Received: from [10.0.0.6] (cnj199.neoplus.adsl.tpnet.pl [83.31.163.199]) by openoffice.home.net.pl (Postfix) with ESMTP id 664FD3C4001; Mon, 14 May 2007 20:37:45 +0200 (CEST) Message-ID: <4648AD91.1000301@iidea.pl> Date: Mon, 14 May 2007 20:42:25 +0200 From: =?ISO-8859-2?Q?Jaros=B3aw_Staniek?= Organization: OpenOffice Polska User-Agent: Mozilla/5.0 (X11; U; Linux i686; pl-PL; rv:1.6) Gecko/20050929 MIME-Version: 1.0 To: Drew References: <46465334.6020504@iidea.pl> <46472046.8000705@wilderness.homeip.net> <715841970705140552v7d6c5b6fgbee98cf256ad05e@mail.gmail.com> In-Reply-To: <715841970705140552v7d6c5b6fgbee98cf256ad05e@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org, lauasanf@wilderness.homeip.net Subject: Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 14 May 2007 18:41:12 -0000 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? -- regards / pozdrawiam, Jaroslaw Staniek Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org