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

2007-05-11 Thread Drew Sanford
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

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 u

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 hav

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, Post

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?

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]> wr

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: "k

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"

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 *

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 everythin

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 r

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 r