Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?

2007-05-15 Thread Jarosław Staniek

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?

2007-05-14 Thread Drew

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?

2007-05-14 Thread Jarosław Staniek

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?

2007-05-14 Thread Drew Sanford

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?

2007-05-14 Thread Jarosław Staniek

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?

2007-05-14 Thread Laurence Sanford

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?

2007-05-14 Thread Jarosław Staniek

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?

2007-05-13 Thread Laurence Sanford

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?

2007-05-12 Thread Jarosław Staniek

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]


Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql?

2007-05-11 Thread Bram Schoenmakers
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?

2007-05-11 Thread Danny Pansters
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]