Skip site navigation (1)Skip section navigation (2) 
Date:      Mon, 14 May 2007 13:42:59 -0500
From:      Drew 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:  <4648ADB3.4010002@wilderness.homeip.net>
In-Reply-To: <4648AD91.1000301@iidea.pl>
References:  <46465334.6020504@iidea.pl>	 <46472046.8000705@wilderness.homeip.net> <715841970705140552v7d6c5b6fgbee98cf256ad05e@mail.gmail.com> <4648AD91.1000301@iidea.pl>
index | next in thread | previous in thread | raw e-mail 

[-- Attachment #1 --]
Jarosaw 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.

[-- Attachment #2 --]
SQLite format 3@  
	
	G.$	vacationVacationdateDateusersUserskeykeyidwId6)vacationfalseVacationWhat they have'%dateDateWhen created'usersUsersUser name--countwcountHow many entries

n>*#
'3 project_descProject description	%
project_desc"-+ project_captionProject caption+
project_caption.97 kexiproject_minor_verProject minor version7kexiproject_minor_ver0.97 kexiproject_major_verProject major version7kexiproject_major_ver1-kexidb_minor_ver8-kexidb_major_ver1
%query_layout7SELECT * FROM table11sql
table11Table11query1Query1table1Table1

.!=Querieskexi/queryhttp://koffice.org/kexi/-!=Tableskexi/tablehttp://koffice.org/kexi/
q%%qtablekexi__fieldskexi__fieldsCREATE TABLE kexi__fields (t_id Integer UNSIGNED, f_type Byte UNSIGNED, f_name Text(200), f_length Integer, f_precision Integer, f_constraints Integer, f_options Integer, f_default Text(200), f_order Integer, f_caption Text(200), f_help CLOB)Xtablekexi__dbkexi__dbCREATE TABLE kexi__db (db_property Text(32), db_value CLOB)--Ktablekexi__objectdatakexi__objectdataCREATE TABLE kexi__objectdata (o_id Integer UNSIGNED NOT NULL, o_data CLOB, o_sub_id Text(200))
rwotabletable11table11CREATE TABLE table11 (id INTEGER PRIMARY KEY, "key" Integer, users Text(200), date Text(200), vacation Text(200))	mtabletable1table1
CREATE TABLE table1 (count INTEGER PRIMARY KEY, users Text(200), date Date, vacation Boolean NOT NULL DEFAULT 0)&''tablekexi__objectskexi__objectsCREATE TABLE kexi__objects (o_id INTEGER PRIMARY KEY, o_type Byte UNSIGNED, o_name Text(200), o_caption Text(200), o_desc CLOB)C##Mtablekexi__blobskexi__blobsCREATE TABLE kexi__blobs (o_id INTEGER PRIMARY KEY, o_data BLOB, o_name Text(200), o_caption Text(200), o_mime Text(200) NOT NULL, o_folder_id Integer UNSIGNED)##]tablekexi__partskexi__partsCREATE TABLE kexi__parts (p_id INTEGER PRIMARY KEY, p_name Text(200), p_mime Text(200), p_url Text(200))

zz #!Johny Myung2005-02-01true!Liv Tyler2004-10-12false!#!Steve Tyler2003-05-25false!Joe Perry2005-02-01true
help

Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4648ADB3.4010002>