Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
Laurence Sanford said the following, On 2007-05-15 00:41: I see where this is going. Actually, in the original db that I created, there is no conflict with key rather it appears to be start. However, I can specify that and get (correct) output from the queries. It looks like the problem is related specifically to using * in the select statement. Kexi keeps dropping the *. Found a solution, and published patch (agains KOffice 1.6.2): http://kexi-project.org/wiki/wikiview/index.php?Kexi1.1.2_Patches Please let me know if you're able to compile the code. -- 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 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
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 [EMAIL PROTECTED] wrote: Jarosław Staniek wrote: On 12 Maj, 02:41, Danny Pansters [EMAIL PROTECTED] 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 [EMAIL PROTECTED] Test.kexi Description: Binary data ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
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 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
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. Test.kexi Description: Binary data ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
Drew Sanford said the following, On 2007-05-14 20:42: 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. There is _still_ a column called key in table11 you have sent me. Remove the 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; -- 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 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
Jarosław Staniek wrote: Drew Sanford said the following, On 2007-05-14 20:42: 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. There is _still_ a column called key in table11 you have sent me. Remove the 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; I see where this is going. Actually, in the original db that I created, there is no conflict with key rather it appears to be start. However, I can specify that and get (correct) output from the queries. It looks like the problem is related specifically to using * in the select statement. Kexi keeps dropping the *. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
Laurence Sanford said the following, On 2007-05-15 00:41: I see where this is going. Actually, in the original db that I created, there is no conflict with key rather it appears to be start. However, I can specify that and get (correct) output from the queries. It looks like the problem is related specifically to using * in the select statement. Kexi keeps dropping the *. I've just found a problem in the source code. Stay tuned... -- 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 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
Jarosław Staniek wrote: On 12 Maj, 02:41, Danny Pansters [EMAIL PROTECTED] 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 [EMAIL PROTECTED]
Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
On 12 Maj, 02:41, Danny Pansters [EMAIL PROTECTED] 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? -- 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 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
Hello, I am using Kexi to track various things in my office, including time off. This works well because I can write queries for each employee showing me how much time they have requested off, etc. - however it appears that after a recent upgrade of all ports, which included a KDE update, SQL no longer works. For instance, I have a table called time_off that has many records in it, but even a simple query such as SELECT * FROM time_off; 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. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
Op vrijdag 11 mei 2007, schreef Drew Sanford: Hi, I am using Kexi to track various things in my office, including time off. This works well because I can write queries for each employee showing me how much time they have requested off, etc. - however it appears that after a recent upgrade of all ports, which included a KDE update, SQL no longer works. For instance, I have a table called time_off that has many records in it, but even a simple query such as SELECT * FROM time_off; 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, -- Bram Schoenmakers You can contact me directly with Yahoo Instant Messenger with bramschoenmakers ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?
On Friday 11 May 2007 22:44:39 Bram Schoenmakers wrote: Op vrijdag 11 mei 2007, schreef Drew Sanford: Hi, I am using Kexi to track various things in my office, including time off. This works well because I can write queries for each employee showing me how much time they have requested off, etc. - however it appears that after a recent upgrade of all ports, which included a KDE update, SQL no longer works. For instance, I have a table called time_off that has many records in it, but even a simple query such as SELECT * FROM time_off; 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 All are in PORTSDIR/databases. Dan ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
