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 6C2D016A404 for ; Mon, 14 May 2007 18:47:21 +0000 (UTC) (envelope-from lauasanf@wilderness.homeip.net) Received: from mail.ecommerce.com (mail.ecommerce.com [80.121.204.32]) by mx1.freebsd.org (Postfix) with SMTP id 7530C13C4BA for ; Mon, 14 May 2007 18:47:20 +0000 (UTC) (envelope-from lauasanf@wilderness.homeip.net) Received: (qmail 29251 invoked by uid 399); 14 May 2007 18:47:17 -0000 Received: from unknown (HELO drew.ecommerce.com) (80.121.204.1) by mail.opentransfer.com with SMTP; 14 May 2007 18:47:17 -0000 Message-ID: <4648ADB3.4010002@wilderness.homeip.net> Date: Mon, 14 May 2007 13:42:59 -0500 From: Drew Sanford User-Agent: Thunderbird 2.0.0.0 (X11/20070502) MIME-Version: 1.0 To: =?ISO-8859-2?Q?Jaros=B3aw_Staniek?= References: <46465334.6020504@iidea.pl> <46472046.8000705@wilderness.homeip.net> <715841970705140552v7d6c5b6fgbee98cf256ad05e@mail.gmail.com> <4648AD91.1000301@iidea.pl> In-Reply-To: <4648AD91.1000301@iidea.pl> Content-Type: multipart/mixed; boundary="------------090809090608020407090000" Cc: Drew , freebsd-questions@freebsd.org 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:47:21 -0000 This is a multi-part message in MIME format. 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. SQLite format 3