Date: Mon, 14 May 2007 07:52:27 -0500 From: Drew <cotharyus@gmail.com> To: "Laurence Sanford" <lauasanf@wilderness.homeip.net> Cc: freebsd-questions@freebsd.org, =?ISO-8859-2?Q?Jaros=B3aw_Staniek?= <js@iidea.pl> Subject: Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql? Message-ID: <715841970705140552v7d6c5b6fgbee98cf256ad05e@mail.gmail.com> In-Reply-To: <46472046.8000705@wilderness.homeip.net> References: <46465334.6020504@iidea.pl> <46472046.8000705@wilderness.homeip.net>
next in thread | previous in thread | raw e-mail | index | archive | help
[-- Attachment #1 --] 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. On 5/13/07, Laurence Sanford <lauasanf@wilderness.homeip.net> wrote: > > Jarosaw Staniek wrote: > > On 12 Maj, 02:41, Danny Pansters <danny@ricin.com> wrote: > > > > > > > yields an empty result. Does anyone have any pointers on what it > > might > > > > > take to get this working again? I have about 30 saved queries, > > none of > > > > > them work any more. > > > > > > > What kind of database? Native (SQLite), MySQL, Postgres? > > > > > > > Kind regards, > > > > > > I think you should install the qt database(s) support you want via > > ports: > > > > > > qt-ibase-plugin > > > qt-mysql-plugin > > > qt-odbc-plugin > > > qt-pgsql-plugin > > > qt-sqlite-plugin > > > qt4-ibase-plugin > > > qt4-mysql-plugin > > > qt4-odbc-plugin > > > qt4-pgsql-plugin > > > qt4-sql > > > qt4-sqlite-plugin > > > qt4-sqlite3-plugin > > > > Hello, > > Kexi does not use qt sql plugins you mentioned above. > > Drew, could you send me an SQLite database file with the problem > > reproduced? > > > I'll try to build one at home (similar system, though they have > exhibited different bugs at times) and see if it does the same thing, if > not, I'll try to put something together for you from work Monday. > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to " > freebsd-questions-unsubscribe@freebsd.org" > [-- Attachment #2 --] SQLite format 3 @ K K 6 )vacation falseVacationWhat they have' %date DateWhen created' users UsersUser name) -key w keyHow 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 7SELECT * FROM table1;sql query1Query1 table1Table1 . !=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)X tablekexi__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)) w rw mtabletable1table1 CREATE TABLE table1 ("key" 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)) !Liv Tyler2004-10-12 #!Steve Tyler2003-05-25 !Joe Perry2005-02-01
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?715841970705140552v7d6c5b6fgbee98cf256ad05e>